Sumproduct error

  • Thread starter Thread starter Gotroots
  • Start date Start date
G

Gotroots

Hi

Why am I getting a #VALUE! error in the following.

=SUMPRODUCT(--(D25,F25,H25,J25,L25,N25,P25<>""))

Thanks if you can help

Gotroots
 
Hi,

You didn't say what you expected the formula to do.

Is it this

=COUNTA(D25,F25,H25,J25,L25,N25,P25)


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Why am I getting a #VALUE! error in the following.
=SUMPRODUCT(--(D25,F25,H25,J25,L25,N25,P25<>""))
Click to expand...

SUMPRODUCT won't accept discontinuous cell references like that.

Do any of those cells contain formulas that return formula blanks ("") ?
 
Sorry about that.

I want to return a numeric value total based on the specified cells
containing a value.

I had used a previous formula which I modified: =SUMPRODUCT(--(P11:P7799<>""))

The above gave a numeric result if 'P' contained a value(s)

So back to the formula I want to use:
=SUMPRODUCT(--(D25,F25,H25,J25,L25,N25,P25<>""))

This should display a numeric value based on D25,F25,H25,J25,L25,N25,P25
containing a value.


Example

F25 and N25 contain a value

Result should then be:

2

Hope this is clear

Gotroots
 
Don't you just want Sum? As in:
=SUM(D25,F25,H25,J25,L25,N25,P25)

Sum will ignore blanks and text for you automatically.

Regards,
Fred
 
Actually the values are all text.

I just want a result returned if where a cell contains any kind of value.

Gotroots
 
Just realised I was trying to crack a nut with a sledgehammer.
The formula =SUMPRODUCT(--(P11:P7799<>""))
modified to =SUMPRODUCT(--(D25:P25<>""))
was ok to use after all.

Thank you guys anyway.

Gotroots
 
So then you want to count the cells. Specifically, counta, as in:
=COUNTA(D25,F25,H25,J25,L25,N25,P25)
will count all non-blank cells.

Regards,
Fred
 
Back
Top