Formula Question for all you BIG BRANES
 

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