I need to count the number for each product which is in column A but use the column name Product because Product may not be in column A all the time.



I used the countif function but in the product field for I may need to select more than one criteria.

Example:
Unsecured Loans can also include secured in the total.

In column B, I need to calculate for each product the total count in that field.

Product Column B
Unsecured Loans 2.

I tried using the countif function and match, it worked but I could not add more than one criteria. Data sample attached.

Attached Files

Test Data 2.xlsx (12.2 KB, 7 views)