Adding a running total

[Wellum18]

Hello. I hope I asking the question properly....I have a column (column A) that has a list of customer numbers. In column E I have charges for customers.

Im trying to find out I can get a total amount of charges per customer. So for a little more information....I may have a customer that has 10 charges and then another customer that may only have 5 charges...so forth and so on.

Essentially Im looking for something that would work like...for lack of a better term...a continuous if statement. It would scan the entire workbook line by line to compare to see if they are equal.

So if A1 and A2 are the same...Add the dollar figure in C1 to C2.
If A3 is the same..add to the sum of C1 and C2.
If A4 is not the same as A3, is it equal to A5. If so, add C4 and C5.
....

Any suggestions would be appreciated. Thanks.

[Pete_UK]

Do you have a separate list of unique customer names/numbers? If so, it would be quite easy to use a SUMIF or SUMIFS formula to get the totals per customer.

Hope this helps.

Pete

[Wellum18]

Thanks for replying.

All the customers numbers are in column A only and they are unique.

So for example customer 101010 may have 10 charges. Customer 105555 may have 5 charges.

Sorry, I didn't ask the initial question properly.

[Pete_UK]

Try this formula in the first row of data (assumed to start in row 2):

=IF(COUNTIF(A$2:A2)=1,SUMIFS(E:E,A:A,A2),"")

then copy this down. The total for each customer will appear only on the first row that the customer number appears.

Hope this helps.

Pete