I've got a list of projects, with customer name and value.
I want to produce a list which has the total value per customer which I can then sort to find who spends most (who doesn't?).
Is there a straightforward way to do this via formula, something along the lines of a sumif, but without having to create a list which only contains each customer name once?
If not, how can I consolidate the original list of customer names (with many duplicates) to contain each customer name once?