Count If

[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

 

[Peo Sjoblom]

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)

 

[James]

thanks Peo, works great

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)