Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have a column of numbers, some positive, some negative.
I would like to count the number of entries that are 3 and are <=7.
What function would I use? Thanks for any help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have a column of numbers, some positive, some negative.
On Mar 23, 8:09*am, Skip wrote:
I would like to count the number of entries that are 3 and are <=7. What function would I use? *Thanks for any help. In xl 2007 look in the help index for countIFS. In less than xl 2007 look in the help index for COUNTIF and AND |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have a column of numbers, some positive, some negative.
On Mar 23, 6:09*am, Skip wrote:
I would like to count the number of entries that are 3 and are <=7. What function would I use? One way: =COUNTIF(A1:A100,"<=7")-COUNTIF(A1:A100,"<=3") More straight-forwardly: =SUMPRODUCT((A1:A1003)*(A1:A100<=7)) =COUNTIFS(A1:A100,"3",A1:A100,"<=7") The last one is the best. But it is available only in XL2007 and later. In the SUMPRODUCT, multiply (*) acts like AND. We cannot use AND in that context. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have a column of numbers, some positive, some negative.
On Mar 23, 1:11*pm, joeu2004 wrote:
On Mar 23, 6:09*am, Skip wrote: I would like to count the number of entries that are 3 and are <=7. *What function would I use? One way: =COUNTIF(A1:A100,"<=7")-COUNTIF(A1:A100,"<=3") More straight-forwardly: =SUMPRODUCT((A1:A1003)*(A1:A100<=7)) =COUNTIFS(A1:A100,"3",A1:A100,"<=7") The last one is the best. *But it is available only in XL2007 and later. In the SUMPRODUCT, multiply (*) acts like AND. *We cannot use AND in that context. Thanks, SUBPRODUCT works great. Thanks again |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a column of numbers, some negative, some positive | Excel Worksheet Functions | |||
How do I convert a column of numbers from positive to negative? | Excel Discussion (Misc queries) | |||
Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
Convert a column of numbers from positive to negative in Excel | Excel Discussion (Misc queries) | |||
How do I change a column of 500 numbers from positive to negative | Excel Discussion (Misc queries) |