mulitple concatenate conditions

[Alchemist]

hiya.
Can you use concatenate with more than one if criteria?
I'm using this currently:
=CONCATENATE((COUNTIF(D591,"*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?

 

[CLR]

Maybe..........

=CONCATENATE((COUNTIF(D591,"*DVD*")+COUNTIF(D591,"*VCR*"))," = DVD")

Vaya con Dios,
Chuck, CABGx3

 

[Sean Timmons]

=CONCATENATE((COUNTIF(D591,"*DVD*")+COUNTIF(D591,"*VCR*"))," = DVD and
VCR")

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