totals

Hi folks, Each month end, I create a copy of the last month's end file. as part of this process, all Report sheets (those that are sent out to the business) have the new month added to their tables. this is done by copying the previous month's (eg October) column, and inserting the copied cells...

HI I have a series of 5 totals for each year, the slope function over the 5 totals returns 57.6 How do I apply the slope to a subset of the totals The total are 2106, 2008, 2147,2288. slope = 57.6 My subset is 131,158,138,132,547. I want to predict the next number ignoring the first 3...

Hi All, I am trying to figure out a better way to get monthly totals for data imported from a Gantt chart into columns A to D. I added a hidden reference column that gets imported to column A in Excel. The table in the image below needs to show the monthly orders for: Australia which...

Hello everyone! I'm afraid this will be a complicated question, but I'll do the best I can to explain. (It would be easier if I could upload my workbook, but the forum won't seem to let me do that. I have two sheets that I'm working with in a workbook. They're called "MONTH END TOTALS" and...

I have a pivot table and tabulates sales data for the Month / Quarter and Year in columns across. The Month Number, Quarter Number and Year are all individual fields. Excel automatically creates a hierarchy by Year then Quarters, then months, all except months have subtotals. It looks like...

Can someone please help I Have a heading, lines of information with formulas and totals at bottom. I would like vba code to insert next line for information with previous line formulas added automatically, but must move down my totals line. in short line inserted between last info and total...

Good Afternoon- I'm trying to figure a code to go through the following processes: I'd like to open Excel- Initial sheet is the Master Template- 1. A dialog box opens with a series of inputs (They establish the "constants" in the formulas) 2. Then Either Sheet 1 "Noon" or the Totals...

Hi all, I have a workbook that logs daily production totals. I am able to count totals for production between dates but for the life of me are unable to figure out how to count the employees. I'm using =SUMIFS(DataBase!H:H,DataBase!A:A,">="&$P$1,DataBase!A:A,"<="&$P$2,DataBase!S:S,O4) to...

Hi, I am looking to utilize conditional formatting to color code a set of totals compared between 2 payroll systems. The one payroll system pays by the minute and will have the format 37:47 for example to show 37 hours and 47 minutes worked that week. The other payroll system rounds to the...

Hi I have just set up my invoicing and I would like to take the total of weekly invoices and place the totals into a monthly budget workbook. As the invoice amounts are changing but the cell with the total doesn't, do I still use the fx calculation of SUM to make this work? Thank you in...

Hi All, Hoping you can help. I am looking to work out blended % formula amount in a row of cells against another 2Rows already populated with % amounts Eg A1 through M1 totals 100% B1 through M1 totals 100% Require blended formula in cells C1:M1 that would also total 100% Thanks!

Hi All, Hoping you can help. I am looking to work out blended % formula amount in a row of cells against another 2Rows already populated with % amounts Eg A1 through M1 totals 100% B1 through M1 totals 100% Require blended formula in cells C1:M1 that would also total 100% Thanks!

Have tried (and googled) this before without success so here goes. Rough example: I have a number of projects with a filter applied at ROW 4, what is the formula in C2/C3 that will generate the totals when the filter is active? Thanks in advance Kev <tbody> A B C 1 Narrative Totals...

I was hoping this would be an easy one to solve, but nothing has worked. The basics of what I have setup: 1. I have a query created which displays all records of one field from my main table called 'serious incidents' 2. The query has a running total of the number of records. 3. on a report...

i have a financial tracking sheet i developed that works fairly well for me. but have run into a wall on it when someone asked me to make a change. so here's what i have: on a quarterly basis, spending amounts and their categories from each week are entered on separate sheets, and there is a...

Occasionally external data errors cause a #N/A in a table and the error carries over into my totals. Is there any way I can keep the totals working normally (obviously without the values associated with the error)?

Hi All, I'm looking to make a simple calculator to help determine when holidays are booked what skills we will lose as a consequence. Simple table below. In my simple thinking, i thought for totals an IF statement would be something as follows: If (B2=1, COUNT C2),If (B3=1, COUNT C3),If (B4=1...

Hello Everyone, I am trying to take a list of addresses and somehow export data from that to give me some totals on the heat type. So essentially I want to take the address and simply convert it to just the town name and the totals of heat type for that town. Normally I would do this manually...

Hi There, My Rank formula isn't working properly and I'm not getting the proper results. I don't mind duplicates which i can fix with some weighted adjustments. I'm getting dupes with different point values which has me baffled. Here's my formula: =IFERROR(RANK(AS3,AS3:AS104,0),"") I'm...

I have a simple =SUM(A1:G1) formula here but it's not working. It's like it's missing column data and giving incorrect totals. Each result (A:G) is populated by an IF formula. Any thoughts why Sum would not be working properly? Auto Calculation is on, which is the only thing i can think of...