It should be


SUBTOTAL(3,range)


or


SUBTOTAL(2,range)


for counting, 9 will sum the values

--


Regards,


Peo Sjoblom


"Ashish Mathur" wrote in message
...
Hi,

If you are using Excel 2007, then you can filter based on colour and then
use the SUBTOTAL(9,range) function.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"mike" wrote in message
...
Can excel count values in a range of cells based on the fill color?
(for example you only want it to count the ones that have the fill
color red. Not count the number of red cells but count the values in the
cells)