SUM of multiple cells on one criteria

[Ioana_S]

Hi guys

I have a table with clients and their order values, they are repeating - so one client has 1 or more than one order.
And I have another table where I need to have the order totals for these clients.

I can't use a pivot here, as I have around 350.000 lines, is there a formula to help me out here?

Thanks so much, guys!

[pjwhitfield]

If you're just looking to sum all values with the same email then:

Please Login or Register  to view this content.

[Ioana_S]

Thanks so much for your help!

[AliGW]

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.