| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count consecutive dates only | Excel Discussion (Misc queries) | |||
| retirning count values from calcualted fields | Excel Discussion (Misc queries) | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Getting Count field to recognise rows with negative values in Exc. | Excel Worksheet Functions | |||
| Count Unique Values | Excel Worksheet Functions | |||
Linear Mode
