VBA - sum every other row
Posted by Mindy on May 30, 2001 3:44 PM
I have a macro which will return the resultset and display the data on the worksheet as following:
row(colume A) value(colume B)
user1 - Vol 10
user1 - Amt 20
user2 - Vol 30
user2 - Amt 40
user3 - Vol
It generates two rows for each user, Vol and Amt.
Total users will depend on the return of the recordsets.
If I need to sum the Vol and sum the Amt, what will be the formula?
The result I am looking for:
total Vol = 40
total Amt = 60
Thank you very much for helping