Counting number of instances a conditional format is met in a colu

[Guest]

I have created a spreadsheet that I want to count the number of cells in a
column that meet a conditional format. Here is the conditional format,
=AND($J1>6.5,$N1<3)
Currenty I use a color to indicate which cells meet the conditional format
and visually add them and manually place that value at the bottom of the
column.
My question is how do I automatically have the count displayed at the bottom
of the column?

 

[Guest]

Try here:-

http://www.xldynamic.com/source/xld.ColourCounter.html#counting

Mike

 

[Roger Govier]

Hi

Try
=SUMPRODUCT(($J$1:$J$1000>6.5)*($N$1:$N$1000<3))

 

[Guest]

You could also try here: http:\\www.cpearson.com/excel there are many
references to working with cell and/or font colors.