add dollar values based on certain criteria.

**Karleajensar** · 11-01-2007, 12:37 PM

In column [A] is a item desination, "0001", "0002", "0003" and so forth.
In column [B] I have names, "TONY", "RICK", "MARY", "KIM".
In column [D] I have a letter designation that describes the status of the item, for example "A"=Active, "D"=Dead, "L"=Lost.
In column [E] I have a dollar value of the item.

So in row [2] is item (a2)"0001" that belongs to (b2)"TONY" that is (c2)"A" (meaning active) and has a dollar value of (d2)$100.00.

I need a formula that will add all of Tony's dollar values.

THEN I need of formula that will add all the dollar values where there is an "A" in in columm [D]. Meaning the dollar value of all a Tony's active items.

Thank you very much for your help.

**NBVC** · 11-01-2007, 12:42 PM

To sum dollars when column B is "Tony":

=Sumif($B$2:$B$500,"Tony",$E$2:$E$500)

To sum dollars when column B is "Tony" and column D is "A":

=Sumproduct(--($B$2:$B$500="Tony"),--($D$2:$D$500="A"),$E$2:$E$500)

adjust ranges to suit... you can replace "Tony" and "A" with cell references...