COUNTIF assistance please...

[Phil]

I have multiple words in single cells throughout a worksheet and would
like to count a selected word from these cells. Is it possible?

=COUNTIF(E76:I83,"PAID") will return a result when PAID is the only
word in the cell but not when other words are in the same cell i.e
PAID, Friday

TIA

 

[Domenic]

Hi,

try,

=COUNTIF(E76:I83,"*PAID*")

Hope this helps!

 

[Peo Sjoblom]

=COUNTIF(E76:I83,"*PAID*")

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Phil]

Thx both, so easy when you know how !

=COUNTIF(E76:I83,"*PAID*")

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)