Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
values greater than and including
I need to find how many values in a column are greater than and including 6
but less than 12, I have tried many variations on COUNTIF and the numbers just dont look right. Can anyone help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
values greater than and including
Hi
Both formulas will do it: =SUMPRODUCT(--(A1:A10=6),--(A1:A10<12)) =COUNTIF(A1:A10,"=6")-COUNTIF(A1:A10,"12") Regards, Per "Teeny" skrev i meddelelsen ... I need to find how many values in a column are greater than and including 6 but less than 12, I have tried many variations on COUNTIF and the numbers just dont look right. Can anyone help? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
values greater than and including
Hi,
You could try either of the following: =sumproduct((range=6)*(range<12)); or =countif(range,"=6")-countif(range,"<12") -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Teeny" wrote in message ... I need to find how many values in a column are greater than and including 6 but less than 12, I have tried many variations on COUNTIF and the numbers just dont look right. Can anyone help? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
values greater than and including
=countif(range,"=6")-countif(range,"<12")
this formula doesn't work. It give you a wrong value "Ashish Mathur" wrote: Hi, You could try either of the following: =sumproduct((range=6)*(range<12)); or =countif(range,"=6")-countif(range,"<12") -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Teeny" wrote in message ... I need to find how many values in a column are greater than and including 6 but less than 12, I have tried many variations on COUNTIF and the numbers just dont look right. Can anyone help? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
values greater than and including
greater than and including 6 but less than 12
=COUNTIF(A1:A10,"=6")-COUNTIF(A1:A10,"12") your formula doesn't work. It give you a wrong value Try it like this: =COUNTIF(A1:A10,"=6")-COUNTIF(A1:A10,"=12") "Per Jessen" wrote: Hi Both formulas will do it: =SUMPRODUCT(--(A1:A10=6),--(A1:A10<12)) =COUNTIF(A1:A10,"=6")-COUNTIF(A1:A10,"12") Regards, Per "Teeny" skrev i meddelelsen ... I need to find how many values in a column are greater than and including 6 but less than 12, I have tried many variations on COUNTIF and the numbers just dont look right. Can anyone help? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
values greater than and including
=SUM(COUNTIF(A:A,{"=6","=12"})*{1,-1})
"Teeny" wrote: I need to find how many values in a column are greater than and including 6 but less than 12, I have tried many variations on COUNTIF and the numbers just dont look right. Can anyone help? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
values greater than and including
Hi,
In 2007: =COUNTIFS(A1:A15,"=6",A1:A15,"<12") In 2003: =SUMPRODUCT(--(A1:A15=6),--(A1:A15<12)) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Teeny" wrote: I need to find how many values in a column are greater than and including 6 but less than 12, I have tried many variations on COUNTIF and the numbers just dont look right. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF result including values not specified in sum-range | Excel Worksheet Functions | |||
How can I count numbers without including the repeated values? | Excel Discussion (Misc queries) | |||
Calculate averages not including zero values | Excel Discussion (Misc queries) | |||
Advanced Filter for Values in Column M greater than Values in Colu | Excel Discussion (Misc queries) | |||
count them number of cells between values -2 and 2 including 0 | Excel Discussion (Misc queries) |