Hi all,

I have a problem,

I want to use the COUNTIF OR SUM IF FUNCTION TO COUNT THE NUMBER OF CELLS DEPENDING ON THEIR COLOUR

FOR EG IN SHEET 1 THERE ARE 6 CELLS RED IN COLUMN F
7 CELLS BLUE IN COLUMN F
8 CELLS GREEN IN COLUMN F

I NEED TO PRINT IN SHEET TO HOW MANY CELLLS IN TOTAL

ARE RED , BLUE AND GREEN

HOW DO I DO THAT BIGH SHOUT OUT TO TONY IN THE FORUM FOR ALL HIS HELP TOO