View Single Post
  #1   Report Post  
mmock
 
Posts: n/a
Default Formula for counting specific cells with value greater than 0

I am looking for a formula that will allow me to count specific cells (not a
range) that would hold a value greater than 1. If the cell had a value of
less than one, it would not be included in the count.
A5 = 1.1
A10 = 1.4
A15 = .75
A20 = 2.3

total count would be 3