Count If

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hello everyone,

I am using the following formula to count the number of times an entry
appears in a list :

=COUNTIF('Full Output'!J:J,"Outlook Edition")

the problem is, there are entries such as "Outlook Edition" but there can
also be entries like "Outlook Edition, Intellisync, Other" - is there any
way in my formula that I can say contains. For example if I'm counting the
number of times that "Outlook Edition" appears, I would like to count it
even if it appears in a string such as "Outlook Edition, Intellisync,
Other".

Thanks very much for your help,

James
 
Try

=COUNTIF('Full Output'!J:J,"*Outlook Edition*")


--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
thanks Peo, works great
Peo Sjoblom said:
Try

=COUNTIF('Full Output'!J:J,"*Outlook Edition*")


--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
Click to expand...
 
Back
Top