Counting Color Cells

[danjw_98]

I tried to use the "=CountIfColor(a1:a10,3) to count the number of red filled cells and it doesn't seem to work - it shows "#name?" in the cell that I have this in.

any suggestions?

 

[Iridium]

This any use?

http://www.cpearson.com/excel/colors.htm

HTH

 

[danjw_98]

I tried that also and it didn't work

 

[Iridium]

Well I know for a fact that it does work so you've done something wrong...

 

[parry]

I tried to use the "=CountIfColor(a1:a10,3) to count the number of red filled cells and it doesn't seem to work - it shows "#name?" in the cell that I have this in.

any suggestions?

What is the CountIfColor function - is it an add-in or your own UDF? Chip Pearsons site is really good and I agree with Iridium that it works just fine.

If you want a quick & dirty way to count the colours you can use this. Theres no error checking.

Sub CountColours()
Dim q1 As Range, q2 As Range, MyColour, c, I As Integer

Set q1 = Application.InputBox("Click on a cell that has the colour you want to count", _
"select Colour", , , , , , 8)

MyColour = q1.Interior.ColorIndex

Set q2 = Application.InputBox("Select the range to look in", _
"Range to count colour", , , , , , 8)

I = 0

For Each c In q2
If c.Interior.ColorIndex = MyColour Then
I = I + 1
End If
Next c

MsgBox "There are " & I & " cells in the range that match your colour"

End Sub

hth

 

[danjw_98]

I entered the "countifcolor(a1:a10,3)" as a formula in cell a12 and i get the #name? in cell a12, I also tried "countbycolor(a1:a10,3)" with the same results. What am i doing wrong?

 

[texasalynn]

There is not a function in Excel "COUNTIFCOLOR". The #NAME says that the formula name is not valid. What happened when you used the suggestion from Chip Pearson's site?

Please give us more info
texasalynn