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

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($J16.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?

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

Try he-

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

Mike

"wader40" wrote:

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($J16.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?

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

Hi

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

--
Regards

Roger Govier


"wader40" wrote in message
...
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($J16.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?

Counting number of instances a conditional format is met in a
 

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


"Mike H" wrote:

Try he-

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

Mike

"wader40" wrote:

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($J16.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?