View Single Post
  #4   Report Post  
Rowan
 
Posts: n/a
Default

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