count coloured cells in a range. Specific colour Red, Green, Blue

S

sizz1

Hi

I have filled in some cells with different colours, using the fill tool
Red
Blue
Green

I need a formula which will calculate each Red cell in a given range?
I need a formula which will calculate each Blue cell in a given range?
I need a formula which will calculate each Green cell in a given range?

Again the range I need will be two different ranges. E.g A1:B5 and
D1:D5

I look forward to your response
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change cell color depending on two cell values 1
Count specific word in a specific range 2
Automatically change the text format the cell when use a specific text 10
Count coloured cells in a range 3
COUNTIFS with OR 5
Count Filled colour in cell in given range 4
Count in a range of numbers 9
cell vlue based on cell back colour 7

Top