Excel Compute LTV Lifetime Value
Super User Asked on November 4, 2021
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!
One Answer
Insert a pivot table and select your range.
Add email to rows and add price to values.
Answered by Moshe Lilintal on November 4, 2021
Add your own answers!
Ask a Question
Get help from others!
Recent Questions
- How can I transform graph image into a tikzpicture LaTeX code?
- How Do I Get The Ifruit App Off Of Gta 5 / Grand Theft Auto 5
- Iv’e designed a space elevator using a series of lasers. do you know anybody i could submit the designs too that could manufacture the concept and put it to use
- Need help finding a book. Female OP protagonist, magic
- Why is the WWF pending games (“Your turn”) area replaced w/ a column of “Bonus & Reward”gift boxes?
Recent Answers
- haakon.io on Why fry rice before boiling?
- Jon Church on Why fry rice before boiling?
- Joshua Engel on Why fry rice before boiling?
- Lex on Does Google Analytics track 404 page responses as valid page views?
- Peter Machado on Why fry rice before boiling?