Can you add the number of conditionally formatted cells??

M

Max

.. add the number of conditionally formatted cells??

Suppose we have applied CF to the range A1:A10
to trigger based on say:
Condition 1, Formula is: =AND(A1>5,A1<8)

Then we could use this "similar-looking" formula in say, B1:
=SUMPRODUCT((A1:A10>5)*(A1:A10<8))
to provide the count of the number of cells triggered by the CF within the
range

Lost said:
Can you add the number of cells in a column or row? If so, how??
Click to expand...
Re: Can you add the number of conditionally formatted cells??
 
Top