Automatic adding of Coloured cells ISSUE

[MFlo85]

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

[Domski]

These UDF's will return either the index of the fill or font colour of a cell.

Please Login or Register  to view this content.

You can then use a pivot table to summarise the results.

This will not work if you are using conditional formatting to colour the cells. If that's the case you should use the same conditions as for the formatting as a basis for a SUMIF/SUMPRODUCT formula.

Dom