Thread: add only positive numbers and avg in a column
View Single Post
  #7   Report Post  
Bob Phillips
 
Posts: n/a
Default

"Biff" wrote in message
...
Hi!

=COUNTIF(A1:A10,"0")/COUNT(A1:A10)

Is zero a positive number?

As positive and negative are defined in terms of zero, it is neither.


Reply With QuoteReply With Quote