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
|