Thread: count number of columns based on values across a row
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 number of columns based on values across a row
As stated in your previous thread:
=COUNTIF(A2:Z2,"0")

--
Best Regards,

Luke M
"r2rcode" wrote in message
...
i need to calcuate the number of columns that have a value greater than
zero
within a particular row.


Reply With QuoteReply With Quote