mulitple concatenate conditions

A

Alchemist

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?
 
C

CLR

Maybe..........

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

Vaya con Dios,
Chuck, CABGx3
 
S

Sean Timmons

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

Will add the count of VCR and the count of DVD.
 
Top