Sumproduct error

[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

 

[Mike H]

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.

 

[Fred Smith]

Certainly we can help. What do you want the formula to do?

Regards,
Fred

 

[T. Valko]

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

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

SUMPRODUCT won't accept discontinuous cell references like that.

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

 

[Gotroots]

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(--(P117799<>""))

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

 

[Fred Smith]

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

 

[Gotroots]

Actually the values are all text.

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

Gotroots

 

[Gotroots]

Just realised I was trying to crack a nut with a sledgehammer.
The formula =SUMPRODUCT(--(P117799<>""))
modified to =SUMPRODUCT(--(D2525<>""))
was ok to use after all.

Thank you guys anyway.

Gotroots

 

[Fred Smith]

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