Counting different products in a column

Hello Dee

Thank you for your question.

You can use the COUNTIF function to count the number of times a specific criteria (in this case, name of a colour) appears within a cell range.

I've attached an example to show how it works. The formulas are in the cells coloured in yellow.

Kind regards
Amanda