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

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!


--
IssieC
------------------------------------------------------------------------
IssieC's Profile: http://www.excelforum.com/member.php...o&userid=34786
View this thread: http://www.excelforum.com/showthread...hreadid=568298

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

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

IssieC Wrote:
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!


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=568298

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

If you want the count, use

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

If you want the sum, use

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

"IssieC" wrote:


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!


--
IssieC
------------------------------------------------------------------------
IssieC's Profile: http://www.excelforum.com/member.php...o&userid=34786
View this thread: http://www.excelforum.com/showthread...hreadid=568298