Search with multiple criteria

[sshweky]

Hi,

I need to look at a range of values that consist of customer name, item # & colors available. I need to know if a specific combination exists in the list. I am using a countifs statement to accomplish this, but I can't figure out the color part. I can't search a range of values to see if a string is contained within a text cell (Find & Match do not work on ranges). Please see the statement I am using below and it is the CriteriaRange3 that I can't figure out.

=COUNTIFS(CriteriaRange1, "Customer Name", CriteriaRange2, "Item Number", CriteriaRange3, ??Contains Red)

Any ideas or another ways to accomplish my goal?

Thank you!!

Steven

 

[T. Valko]

Maybe this...

=COUNTIFS(CriteriaRange1,"Customer Name",CriteriaRange2,"Item Number",CriteriaRange3,"*Red*")

The * are wildcards which mean: any characters or no characters.

 

[sshweky]

Thank you!!! So smart, yet so simple!

 

[T. Valko]

You're welcome!