Hi,

I am having difficulty in finding a solution to my problem.

In column M i have a list of 3 different colours which indicates whether something is on time or not. I need some code or formula that will add up the colours seperately and put them in a table showing the total number of the 3 different colours

Can anyone help