adding up numbers with multiple conditions

ive tried using the sumif function and the dsum function without success, please help me, thank you.

i need to add up the $ value of something if 2 conditions are true, note attached.

\1

so the 2 conditions would be, if a1:a5 = yellow & b1:b5 = r2d2 then add the cells in c1:c5 so answer would be 2700.

yeah im not sure sorry.

Hi there,

The following array formula (i.e. don't press Enter after you've type the formula; instead press Ctrl+Shift+Enter, which signifies this is an array formula. If the formula is entered correctly, you'll see braces {} around the formula in the Formula bar) will do the trick:

{=SUM(IF(A1:A5="yellow",IF(B1:B5="r2d2",C1:C5,0),0))}

HTH

Robert

Hi

Using SUMPRODUCT

=SUMPRODUCT(--(A1:A5="yellow"),--(B1:B5="r2d2"),(C1:C5))

rylo

thank you that works perfectly.

(love this website!!!)