Calculate totals for each product from a series of entries

Hi,

I have a spreadsheet with a list of email addresses and each email address has a series of product entries. I am trying to find the formula to calculate the totals for each email address for each product - some of the email addresses are repeated.

Please could a kind soul help please. I attach an example spreadsheet.

Thank you very much

Stephen

Perhaps a Pivot Table?View attachment query.xlsx

Many thanks for the help - I could kick myself - why didn't I think of that !!! You make it look so easy and that is just what I am after.

Thanks also for providing a copy of the pivot table and I am my way now to try and produce as you suggest.

Thanks once and I really appreciate the quick help !

Best wishes,


Stephen

You're welcome

Hi - you could also try a SumIf function which would also work

Pivot table will also work OK - but if you wanted values which update in real time without needing to refresh (or if you wanted to add new rows afterwards) then sumif may be preferable

For example, =SUMIF(A:A, "test@aol.com", B:B) will add up all products of type 'A' linked to 'test@aol.com'

To find all products linked to test@aol.com you can use:
=SUMIF(A:A, "test@aol.com", B:B) + SUMIF(A:A, "test@aol.com", C:C) +SUMIF(A:A, "test@aol.com", D : D)+SUMIF(A:A, "test@aol.com", E:E)