Subtotal
Dear Bob,
Excellent. Job done.
Regards
Mat
"Bob Umlas, Excel MVP" wrote:
Select all the blank cells (or Select col A, then edit/goto/special, click
blanks). Once the "correct" cells are selected, simply single click the Sum
tool!
Bob Umlas
Excel MVP
"Mat" wrote:
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
|