View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
R.M. R.M. is offline
external usenet poster
 
Posts: 1
Default 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.