| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count cells in a document, but excude cells with a "0"
I want to count the number of cells that have a value greater than "0", but
not use a range. The cells that will be counted are every other cell in that column. EX: 45 22<-- 18 6<-- 9 17<-- 2 0<-- so my answer would be "3", the amount of cells that have a value greater than "0". the arrows are not on the work sheet they are just used to point out which cell I need counted. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Count non blanks" if cells don't equal certain values | Excel Worksheet Functions | |||
| Count the number of cells that conatin a "." in a range | Excel Worksheet Functions | |||
| use "countif" function to count cells by colour | Excel Worksheet Functions | |||
| how can i save "floating cells" in an excel document?? | New Users to Excel | |||
| Count cells that contain "Y" in columnA IF contains"X" in columnB | Excel Worksheet Functions | |||
Threaded Mode
