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