Formula Question for all you BIG BRANES

D

Dave Melvin

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

Thanks,

Dave
 
R

Rowan

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
 
D

Dave Melvin

Rowan said:
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
Click to expand...

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

Dave
 
R

Rowan

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
 
B

Bob Phillips

Bit simpler

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

--

HTH

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

Amedee Van Gasse

In <[email protected]>, Dave Melvin told us
an interesting story. My reply to this story is at the bottom of this
message.
That was quick! Thanks Rowan. (And I was speaking cosmologically).
Click to expand...

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