Count coloured cells in a range

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
 
B

Bob Phillips

As before (many times)!

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 

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

Count Specific word in specific range 2
count coloured cells in a range. Specific colour Red, Green, Blue 1
Count Filled colour in cell in given range 4
Count If Specific word in specific range 2
Count specific word in a specific range 2
Count Specific word in Specific range 1
cell vlue based on cell back colour 6
Count coloured cells in range 2

Top