function for counting cells

[michael]

I am using a conditional format which blacks out cells
that don't match my criteria... I then want to add the
number of cells that have not been blacked out in a
certain row...

I want to "count cells in Row that are not filled in with
black"

Thanks in advance.

 

[drabbacs]

See this site:
http://www.cpearson.com/excel/colors.htm

Just a thought. Instead of 'blacking out cells' you could
use filters (data> filter> autofilter or advanced filter)
and the SUBTOTAL command. I don't know if that meets your
design criteria though.

 

[Peo Sjoblom]

Reverse the criteria, if for example you black out cells that are =5

then you could use

=COUNTIF(Range,"<>5")