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

  • Thread starter Thread starter IssieC
  • Start date Start date
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!
 
suppose you data is in the range of A1:A50, use following function
=SUMIF(A1:A50,">0.01")
 
If you want the count, use

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

If you want the sum, use

=sumif(A1:A100,">.01,A1:A1000)
 
You must log in or register to reply here.

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

Conditional Counting 7
Count values, excluding duplicates and specific values 2
count if 5
need help on either doing a loop and counting specific values orusing subtotal function 2
criteria for two different cells in a count if function 2
Counting 5
Count functions 4
Data Validation - Complex Q 2

Back
Top