totals

I am currently configuring a financial report which lists description data as well as financial data. I will post a copy of the layout below. What I'm looking to do, is to create a macro which would allow me to create a blank row above any row which contains the word Totals. I'd then like to...

Need some help please I have a tab with quite a few columns and need totals Col A = Staff Names Col B = Course Name Col C = whether they have Pass or Fail Col D = uk or non uk i wish to creat a new tab and count how many staff have pass or fail and if they sit in Uk or non uk New tab with...

<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody> Hello all. I have a head banger issue. Any and all help is a greatly appreciated. This data is exported from an application. I am working with Excel 2016. My attachment shows the...

If I'm on week 1 and I have a column titled Week 1 that shows totals of other columns in week 1 is there a way when I open the spreadsheet next week that the same column will automatically update to Week 2 and show the totals of the week 2 columns? Basically I have a spreadsheet of employees...

Don't know why I'm finding this so difficult and search engines don't seem to help. Have spreadsheet with a total for each day. I want a Line Chart where the totals are on the Y-axis and the week numbers are on the X-axis with one line for Monday, one line for Tuesday, etc. Seven lines in all...

I've been researching thisbut none of the answers I found seemed to make sense in what I am doing. I have the following code: ' find last row findlastrow = Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row lastrow = findlastrow lastrow = lastrow - 1 ' set...

I have a spreadsheet which i use record my daily profit and Loss (Daily PL) i have the 365 days of the year in column A descending. At the end of the year i collate the final numbers and these are stored on another worksheet (Totals) in weekly and monthly form this worksheet has several years...

How do I delete every row of my spreadsheet where the wording "Customer Totals" is listed in Column C of the same row?

Hello friends! Unfortunately I am not permitted to upload the sample spreadsheet so I'll describe it. I am practicing with a formula from a test table with Qtr1-Qtr4 on top and NE,SE,NW,SW on the left, Totals at the far right and bottom with sample numbers in the cells. I have saved the Names in...

Is there a way to multiply every cell from Column D19 through D50 by their corresponding numbers in column G19 through G50 and adding the totals? i.e. =(D19*G19)+(D20*G20)+(D21*G21)+(D22*G22)+(D23*G23)+(D24*G24)+(D25*G25)+(D26*G26)...etc.? I'm doing it long-hand but thought there may be a way...

I would be grateful to receive a steer as to the formula to use, where I have a list, that involves 20 names, in 5 different areas identified by an abbreviated label, and those names fall into either T or C types which alter frequently although the area and name does not. I need to produce a...

I'm looking to sum the column totals in column O to T and have the totals appears in Cell O1 to T1

I am trying to run a macro to edit a table's formatting including table totals. Some tables do not have table totals and this is creating an error. How do I insert an is error inside my code? Range("A2").Select ActiveSheet.ListObjects("Table1").TableStyle = "TableStyleMedium8"...

Hello, I have reports that are in whole dollars and decimals with subtotals and totals. I need to report these in thousands. The round(x,-3) formula works for presentation for the individual rows and totals, but the sum does not equal the rounded totals and subtotals. I end up having to add...

I have a data base with dates in column C, Category in column G, and Amounts in column R. On a sheet2 I have the start date in B2 and end date in B3 and in Column A I have the category names. In column B, I want to get the totals from column G (sheet 1) for rows within the date range and match...

Hello all! I have been struggling with this ridiculous formula for longer than I even want to admit, so now I'm here begging for help. I'll try to explain this as clearly as I can: What I have to work with: Sheet 1 is called "Totals" Sheet 2 is called "COMPLETE" Totals has a table on it...

Hi all, I would like to use a VBA code so that to “SUM” the rows from col. “B” to “N” if the left 7 characters in col. “A” are same. I present below the original data and expected result. Thank you all in advance Original data <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings>...

MACRO TO BOLD, HIGHLIGHT & CHANGE FONT COLOR OF CERTAIN CELLS IN A COLUMN I’m embarrassed to say how long I’ve been searching for an answer to the following problem: The last column(“H”) on my spreadsheet contains the numeric totals of expenses in each row. There are also spaces between some...

Hi all, I'm looking for help in trying to achieve the following. If any of the values in a range is >1, then use the corresponding name from column A. The comments in the code below will hopefully explain what I'm hoping for. I've also created a table for reference. Thanks in advance Sub...

Hi, I have a budget template that has IF statements to exclude costs bases on the max allowed ($25,000) and the previous years' totals. I have 4 groups of these per year for 6 years and all the IF statements appear to be set up the same and work in all but one of the groups and I can't figure...