Formula for counting specific cells with value greater than 0

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting spefic cell (not a range) with a value greater than 1 5
count cells in a document, but excude cells with a "0" 1
Counting if Date1 is after and Date2 is before another date 5
Counting Problem 2
greater than.. 5
Counting Specific Text 2
Formula Problem 6
Make the sum of cells no greater than X 0

Top