View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jamie Jamie is offline
external usenet poster
 
Posts: 3
Default Count cells with positive numbers

My thanks to Gary"s Student and L. Howard Kittle.
One question though, by putting the quotation marks around 0, doesn't
that change it into a text? I thought Excel can understand numeric argument.

"Jamie" wrote in message
...
In a row of 20 cells from A1:T1, how can I count the number of cells that
are greater than 0?
Thanks for your help.

Jamie