TransWikia.com

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. enter image description here

Answered by Moshe Lilintal on November 4, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP