Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting cells that are 0 in a range of non-contiguous cells
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pasting non-contiguous range of cells to new row, same cell locati | New Users to Excel | |||
Counting cells base on a predetermined range | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel | |||
counting cells in a range | Excel Discussion (Misc queries) |