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

[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!

[starguy]

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

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!

[Duke Carey]

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