Sum Formula Help

[wazzulu1]

Hi, Quick question;


I have a name that I'm referencing in column G655 for a drop down list used in the spreadsheet. I want to summarize all the transactions associated with the name in column H655, based on the range of data in Column AN, rows 11 to 655, only if the name matches what's in Column AS for the same row.

How would this be constructed in a formula, or would I need to use a macro instead?

I appreciate any help.

 

[Asala42]

I have a name that I'm referencing in column G655 for a drop down list used in the spreadsheet. I want to summarize all the transactions associated with the name in column H655, based on the range of data in Column AN, rows 11 to 655, only if the name matches what's in Column AS for the same row.

If I follow you correctly, are you looking for a SUMIF?

=SUMIF($AS$11:$AS$654,H655,$AN$11:$AN$654)

Assuming I understand correctly that:
H655 contains the name you're trying to summarize
AS11:AS654 contains names you're hoping to match to H655
AN11:AN654 contains the data you want to sum

 

[wazzulu1]

Yes, this is the answer I needed!

Thank You so much for your help!

(I'm trying to learn, and this place is a tremendous help)

 

[Brian from Maui]

Yes, this is the answer I needed!

Thank You so much for your help!

(I'm trying to learn, and this place is a tremendous help)

You also might try using a Pivot Table.

 

[wazzulu1]

How Brian?

Never did one before.

 

[Brian from Maui]

How Brian?

Never did one before.

This is from Jon Peltier, who is a frequent contributor here on the board.

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=553

 

[wazzulu1]

Thanks, I'll have to study this.