lookup for large data

[jking1]

Hi,

I've spent a few hours on this now, done some research but I cant seem to find an answer. Here's the problem I am facing;

I have extracted data from our ledger of all invoices raised during a specific period. Column A states the client name, Column B states the net value of the invoice. However, this list is of all invoices and therefore the same client will show multiple times. I am in need of formula that will look down Column A & B and will add up all values that relate to the client. I have attached a screenshot of what the data looks like. In this example I'd be looking for a formula to say all Apples add up to x.

 

[arthurbr]

Try the SUMIF function or a Pivot Table

 

[Fluff]

How about

=LET(u,UNIQUE(FILTER(A2:A1000,A2:A1000<>"")),CHOOSE({1,2},u,SUMIFS(B:B,A:A,u)))

 

[jking1]

Ah-many thanks! Cant believe I didn't think of that sooner.