How do I count only values which are over a certain amount?

I

IssieC

I want to count the number of items in a column which are over a certain
level. For example, I want the total of all items which are over 0.01
in value. Please help!
 
S

starguy

suppose you data is in the range of A1:A50, use following function
=SUMIF(A1:A50,">0.01")
 
D

Duke Carey

If you want the count, use

=countif(A1:A100,">.01")

If you want the sum, use

=sumif(A1:A100,">.01,A1:A1000)
 
Top