Thread: Sum data without subtotals

I need help summing data without subtotals because I dont want the summary below the data.

Example of current data:

Loc Cust # Sales
123 7890 $100
123 7890 $75
123 4567 $500
123 4567 $200


I would like to be able to sum by customer # so it looks like:

Loc Cust # Sales
123 7890 $175
123 4567 $700


I apologize if a similar post has been solved. I am brand new to this forum and urgently need assistance.

Thank you.

Sounds like a job for SUMIF. So if your data are in Columns A-C and you want results in D-F, in F1 enter:

=SUMIF(B$1:B$100,$E1,C$1:C$100)

Thank you for the quick reply, but this does not seem to be working. All totals are 0.

Can you upload an excerpt from your file so I can check the references? Chances are I've just assumed the data was somewhere that it's not, so it should be a fairly easy fix.