I have a simple spreadsheet of transactions that contains ONE common field: email address.

How could I create a pivot table or something that has a Total of all the transactions under an email address? (some contacts have 3 or 4 transactions all with the same email address.)

the two columns are:

email | price

I'd like the output to be email | Total (sum of all transactions under a given email)


1 Answer 1


Insert a pivot table and select your range. Add email to rows and add price to values. enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.