Maybe..........

=CONCATENATE((COUNTIF(D5:D91,"*DVD*")+COUNTIF(D5:D 91,"*VCR*"))," = DVD")

Vaya con Dios,
Chuck, CABGx3



"Alchemist" wrote:

hiya.
Can you use concatenate with more than one if criteria?
I'm using this currently:
=CONCATENATE((COUNTIF(D5:D91,"*DVD*"))," = DVD")

How could I use the above to search more than one criteria such as "DVD" and
"VCR" instead of only "DVD"? Concatenate works fine except I cannot search on
multiple terms. Can be done with another function maybe?