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

"T. Valko" wrote:

they all return "#Value"
3rd try =SUMPRODUT((A1:A3="x")*(B1:B3+C1:C3+D1:D3))

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

=SUMPRODUCT((A1:A3="x")*B1:D3)

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 B1:D3.
Are there any formulas in the range that return formula blanks?

--
Biff
Microsoft Excel MVP


"TJSea" wrote in message
...
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:D. I've taken a stab at it with the following formulas,
but
they all return "#Value"

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

Any advice???


.