Hi, Any help would be greatly appreciated.
Column A contains different divisions (there will several lines for each
divison).
If Col C1 contains a 1 then the amount in Col B1 is to be calculated for
each like division in Col A
Example:
First line Col A (1), B ($-7954.07), C (1)
Second line A (1), B ($1000.00), C (blank)
Third line A(1), B ($50.00), C (1),
In Col D a list of each division
Col E for the example above would be totals from line 1 and line 3
$-7904.07 which would go in Col E (Col D is a list of all the different
divisions)
And then so forth for each division.
Thanks
Donna