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.


"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

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

Regards,
Fred

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

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

--
Biff
Microsoft Excel MVP


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

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

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

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

.

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



"Gotroots" wrote:

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

.

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


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

.