Prev: 2003 documents converted to 2007, lines drawn in are misaligned
Next: Form and protect sheet
From: TJSea on 5 Apr 2010 11:24
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" <TJSea(a)discussions.microsoft.com> wrote in message
> news:AC0E9D24-C06F-4D28-98CA-029CEC598018(a)microsoft.com...
> > 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???
>
>
> .
>
 | 
Pages: 1
Prev: 2003 documents converted to 2007, lines drawn in are misaligned
Next: Form and protect sheet