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?
|