Thread: Count Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Grant
 
Posts: n/a
Default Count Question

I am trying to count the number of cells that are no equal to 0.
COUNTIF(L:L,"<0") includes all the blank cells. I need to count cells
that are not blank and not equal to zero.

T.I.A.
Ed