Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.
Sign up to join this community
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)
Thanks!
Insert a pivot table and select your range.
Add email to rows and add price to values.
