mulitple concatenate conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Maybe..........

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

Vaya con Dios,
Chuck, CABGx3
 
=CONCATENATE((COUNTIF(D5:D91,"*DVD*")+COUNTIF(D5:D91,"*VCR*"))," = DVD and
VCR")

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