technocraze
11-01-2008, 02:56 AM
Hi Guys,
May I know whether is there such function in excel whereby I will be able to track the number of coloured cells and sum it?
For example:
A1 - green coloured cell
A2 - orange coloured cell
A3 - green coloured cell
A4 - purple coloured cell
A5 - green coloured cell
A6 - purple coloured cell
Count
green = 3
orange = 1
purple = 2
I do know there is such function COUNTIF(A1: A6), but nt too sure hw to continue from there. Any help will be much appreciated.
May I know whether is there such function in excel whereby I will be able to track the number of coloured cells and sum it?
For example:
A1 - green coloured cell
A2 - orange coloured cell
A3 - green coloured cell
A4 - purple coloured cell
A5 - green coloured cell
A6 - purple coloured cell
Count
green = 3
orange = 1
purple = 2
I do know there is such function COUNTIF(A1: A6), but nt too sure hw to continue from there. Any help will be much appreciated.