counting cells that are 0 in a range of non-contiguous cells
One way:
As long as the cells will *ONLY* contain numbers (no formula blanks either):
=(R460)+(R730)+(R990)+(R1250)+(R1510)+(R1770 )+(R2030)
Biff
"Mark" wrote in message
...
I want to count how many of a group of specific cells contain a number 0
where the range of cells is non-contiguous or non-bordering. ie. not
(A1:A10)
Here is an example of what I am tyring, but it is not working correctly:
=COUNTA("R46,R73,R99,R125,R151,R177,R203","0")
The cell references in quotes are the 'range' and 0 is the value. All of
the cells in the range have formulas, but only 2 of them currently result
in
a value 0, so the total should be 2. As the other formulas create
values,
that number would go up.
I can't find any solid explanation of how to count to a cell range of
specific cells vs. a row, cloumn or table of cells. Any suggestions?
thanks.
|