Auto sum rows with variable content and amount of rows above

**jjohnston@roots.com** · 06-06-2013, 04:00 PM

Every day at work I run a report that requires sum calculation every few rows. However, the number of rows above each sum have varying content and number of rows, so subtotalling wont work. I have been going through and pressing autosum in every sum row cell and dragging it across it is very time consuming and frustrating. Then I have to copy & paste the sell through formula in the last 2 columns.

Can anyone help me with how to get excel to recognize the rows that need summed and that it should only sum the rows after a previous autosum? I'm really not sure what the best method is to get these sums and sell through percentages.

I hope I have explained myself ok...

Thank you

Attached is an example file:

Mock Style Report 2.xls

**Pete_UK** · 06-06-2013, 05:53 PM

Have you tried using Data | Subtotals ? For each change in column B, identify the columns for which you want subtotals, and specify the action (SUM).

You might need to change some of your titles.

Hope this helps.

Pete

**Excel_Explorer** · 06-06-2013, 11:14 PM

OK so this is my first reply to this forum. But I hope it's help, 'cause I tried and it worked.
1. Select all data
2, copy E4 to M4
3. Use to Autofilter and filter blank only
4. Paste the value on the first blank row. Cell E7 to M7
5. Drag the paste value to row 488. It will fill up all the auto sum to the blank cell without going row by row.
6. Unfilter/remove filter and you can see that all the sum should be filled in.

Good luck
Not an expert but just playing with excel