Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal
Dear Mate,
I have data in colum A which has revenue on each row and a blank row after every regular intervals but the row count is different in each row . I need to put subtotal formuls in each blank row. For eg. Col A 399.2 38.5 5.0 0.2 Subtotal (A1-A4) 0.3 Subtotal (A5) 0.3 Subtotal (A6) 9.2 2.2 0.8 0.3 0.1 0.1 0.1 Subtotal (A7-13) 5.2 0.5 Subtotal (A14-15) Regards mat |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I Subtotal, then Sort by Subtotal Amounts? | Excel Discussion (Misc queries) | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
copy subtotal value only, subtotal value can be vlookup by others | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |