Control breake report

P

pol

Hi all,

I have an excel with the following structure. I wat the sum of the amount
just near to the next column of the 'Amount'. I cannot use subtotal because
subtotal will not work here. I kindly request ur advice to write a macros
using
For loop
if the row is blank <blank row> then find the sum of the previous row
which is not blank and put that sum in next column.

Catagory Group Amount
-------------------------------------------------
A A group 12.70
-3.20
1.00 10.50
<blank row>

B A Group 12.20
-3.20
1.00 10.00
<blank row>
A A Group 12.20
-3.20
1.00 10.00


Please help
 
M

Mike H

Hi,

You don't need a macro. Assuming your data to sum starts in C2, Put this in
D2 and drag down

=IF(C3<>"","",SUM($C$1:C2)-SUM($D$1:D1))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top