Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count cell except those contain zero
Dear all
I have a file which include data in more that 5000 lines. I need to count cell column by column, as number except those cells contain zero. For example olumn b have 5500 but 1500 include zero. So as a result i should sse that i have 4000 cells with data. Thanks in advance for your valuable time. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count cells, then reset count when value in another cell changes | Excel Worksheet Functions | |||
How to auto count data in an empty cell to be 0. Blank cell=0 | Excel Discussion (Misc queries) | |||
count cell if value present in every other cell + criteria | Excel Worksheet Functions | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions |