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

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