Hi
one way: just add the COUNTIF statements.
Another way:
=SUM(COUNTIF(A1:A100,{"*aol*","*America Online*","*america on-lin*"}))
--
Regards
Frank Kabel
Frankfurt, Germany
Liz G wrote:
Hi,
One more question. I have a countif formula (see post: variation on
countif) that reads Countif(A1:A100, "*value*"). The situation users
were asked to list their past isp's and could list more than one in a
cell. So, is there a way to say "Count this cell if the cell
includes 'aol', 'america online', OR 'america on-line'"?
Thanks for your help!
Liz
|