Thread: How do I count only values which are over a certain amount?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey Duke Carey is offline
external usenet poster
  
Posts: 1,081
Default 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


Reply With QuoteReply With Quote