Actually the values are all text.

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

Gotroots

"Fred Smith" wrote:

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" wrote in message
...
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



"Mike H" wrote:

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.


"Gotroots" wrote:

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

.