Using countif on non-consecutive cells
Non Volatile formula
=COUNTIF(A1:A5,1)+(A7=1)+COUNTIF(A15:A18,1)
"Marty" wrote:
How do I use the countif on non-concecutive cells, i.e. I want to know the
number of certain cells in worksheet that contain a specific value. For
instance, how many cells in a1:a5, a7, a15:a18 contain the value of 1.
--
Marty
|