Lookup value in a range and add all corresponding cells

[00pumpkin]

Trying to create a formula that looks up a persons name from a ledger and return's all the transactions that person has and totals them.

So in the example below, I want to know everything that has been paid out to John:

Excel 1.PNG

Thanks for your help!

[ragulduy]

=SUMIF(A2:A10,"=John",C2:C10)

[AYData]

Removed due to previous reply

[mikeTRON]

in cell f4:

Please Login or Register  to view this content.

but you will have to remove the "?" after john.

Are you familiar with pivot tables? That might do exactly what you are looking for. Also, for future reference it is better to post a sample data set vs a photo.

[00pumpkin]

Thanks guys, that worked! I'm trying to create a macro that pulls the balance from this ledger onto another ledger. I don't know about making this ledger into a pivot table first and then pulling the data with a vlookup? I've never pulled data out of a pivot table.

[ragulduy]

As a macro you would need something more like:

Please Login or Register  to view this content.

[mikeTRON]

Why bother with a macro if you can use excel functions to do it instead (which makes it much easier to audit IMO)?

It is very easy to use a pivot table to aggregate data then use vlookups to summarize on another sheet, if you need the pivot table to aggregate. You could also just use thje pivot table AS the dashboard or summary sheet OR you could use the sumif formula in the summary sheet.