sum multiple columns with SUMIF or SUMPRODUCT

[TJSea]

I'm running Excel 2003 and am having trouble with what I thought should be a
relatively simple formula. Given a matching criteria in column A, I'd like
to sum columns B. I've taken a stab at it with the following formulas, but
they all return "#Value"

1st try =SUMIF(A1:A3="x","B13)
2nd try =SUMPRODUCT(--(A1:A3="x"),B13)
3rd try =SUMPRODUT((A1:A3="x")*(B1:B3+C1:C3+D13))

Any advice???

 

[T. Valko]

they all return "#Value"

3rd try =SUMPRODUT((A1:A3="x")*(B1:B3+C1:C3+D13))

Try #3 should work although it can also be written like this:

=SUMPRODUCT((A1:A3="x")*B13)

If either of those return a #VALUE! error then you either already have
#VALUE! errors in the range or there is most likely TEXT in the range B13.
Are there any formulas in the range that return formula blanks?

 

[TJSea]

Thank you! I checked for text in the cells and found that was the issue. I
appreciate your help.