Adding cell values that are dependent on adjacent cell values

**globulous** · 10-27-2009, 10:19 AM

Here's an example of what i'm working with,...

Range is C40:D48

Please Login or Register  to view this content.

What i want to do is...

If C40:48 = WAS, then add up all the values in D40:48 for which this is the case.

Same for if C40:48 = PHI... add up the adjacent D values..

The results i will just stick somewhere off to the side.. i just need a formula for now..

The values in C ("WAS" and "PHI") will change, so in the function, obviously a cell reference is required, not the literal "WAS" or "PHI"...

can anyone help?? this is really simple i think, but i figure it's faster asking rather than trying to deal with Excel's bogus help files..

**DonkeyOte** · 10-27-2009, 10:20 AM

see the SUMIF function

=SUMIF($C$40:$C$48,$A1,$D$40:$D$48)

where A1 contains code of interest

**globulous** · 10-27-2009, 10:24 AM

That's perfect... thanks Donkey

**globulous** · 10-27-2009, 10:27 AM

Actually.....

there's 1 more thing...

That function sums certain values from certain range based on certain criteria...

There must be a similar function that returns ENTIRE ROWS from a certain range, based on certain criteria...

i'd like to scan a couple of columns and return the entire row where a particular value is found in the scanned column... is there a function to do this? or is this the work of a macro??