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