Thread: count the number of rows with entries greater than zero
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
  
Posts: 457
Default count the number of rows with entries greater than zero
=COUNTIF(A2:Z2,"0")

--
Best Regards,

Luke M
"r2rcode" wrote in message
...
i need a formula that will look at the information in a range of column
within a row. if the number in a column is greater than zero, then i need
to
add one to the total. this will allow me to know the number of columns
with
values greater than zero.


Reply With QuoteReply With Quote