Using COUNTIF (range, "text"), no problem. Would like to use COUNTIF(range,
"text" or "other text"). Is this possible?

Thanks,

Dave

Don't you mean big BRAINS? <g

=SUMPRODUCT((Range="text")+(Range="text"))
eg
=SUMPRODUCT((F1:F22="a")+(F1:F22="b"))

or

=COUNTIF(Range,"Text")+COUNTIF(Range,"Text")

Hope this helps
Rowan

"Dave Melvin" wrote:

Using COUNTIF (range, "text"), no problem. Would like to use COUNTIF(range,
"text" or "other text"). Is this possible?

Thanks,

Dave

"Rowan" wrote in message
...
Don't you mean big BRAINS? <g

=SUMPRODUCT((Range="text")+(Range="text"))
eg
=SUMPRODUCT((F1:F22="a")+(F1:F22="b"))

or

=COUNTIF(Range,"Text")+COUNTIF(Range,"Text")

Hope this helps
Rowan

"Dave Melvin" wrote:

Using COUNTIF (range, "text"), no problem. Would like to use
COUNTIF(range,
"text" or "other text"). Is this possible?

Thanks,

Dave




That was quick! Thanks Rowan. (And I was speaking cosmologically).

Dave

You're welcome, and I looked it up, so we both ended up learning something,
although to be honest I don't think I understood it <bg.

Main Entry: brane
Part of Speech: noun
Definition: in physics, any dimensional or extended object in string theory
Example: Our universe is a 3-brane.
Usage: science

Regards
Rowan

"Dave Melvin" wrote:

"Rowan" wrote in message
...
Don't you mean big BRAINS? <g

=SUMPRODUCT((Range="text")+(Range="text"))
eg
=SUMPRODUCT((F1:F22="a")+(F1:F22="b"))

or

=COUNTIF(Range,"Text")+COUNTIF(Range,"Text")

Hope this helps
Rowan

"Dave Melvin" wrote:

Using COUNTIF (range, "text"), no problem. Would like to use
COUNTIF(range,
"text" or "other text"). Is this possible?

Thanks,

Dave




That was quick! Thanks Rowan. (And I was speaking cosmologically).

Dave

Bit simpler

=SUMPRODUCT(--(F1:F22={"a","b"}))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rowan" wrote in message
...
Don't you mean big BRAINS? <g

=SUMPRODUCT((Range="text")+(Range="text"))
eg
=SUMPRODUCT((F1:F22="a")+(F1:F22="b"))

or

=COUNTIF(Range,"Text")+COUNTIF(Range,"Text")

Hope this helps
Rowan

"Dave Melvin" wrote:

Using COUNTIF (range, "text"), no problem. Would like to use
COUNTIF(range,
"text" or "other text"). Is this possible?

Thanks,

Dave

In , Dave Melvin told us
an interesting story. My reply to this story is at the bottom of this
message.

"Rowan" wrote in message
...
Don't you mean big BRAINS? <g

That was quick! Thanks Rowan. (And I was speaking cosmologically).

I get it!!!
ROTFLMAO!!!!!
(I'm a big fan of Hawking, Penrose,...)

--
Amedee Van Gasse