M
mmock
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
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