count if function, Index and Match
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.
|