| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Greater and less than
I've typed in this formula to count the number of items that are within the
range that is more than 30 but less than 61 looking at one column with different values, =COUNTIF(N2:N8000,"<3161") I've done one for less than 31 and it works but can't add the second criteria. It should return a value of 98 but I keep getting 0. Where am I going wrong? Thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Greater and less than
You could just count all those greater than 30 and then subtract the number
greater than or equal to 61. What's left are those in the range (30,61) =countif(n2:n8000,"30")-countif(n2:n8000,"=61") "SUMSUE" wrote: I've typed in this formula to count the number of items that are within the range that is more than 30 but less than 61 looking at one column with different values, =COUNTIF(N2:N8000,"<3161") I've done one for less than 31 and it works but can't add the second criteria. It should return a value of 98 but I keep getting 0. Where am I going wrong? Thanks in advance |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Greater and less than
Use SUMPRODUCT:
=SUMPRODUCT(--(N2:N8000<31),--(N2:N800061)) Does that help? Regards, Paul -- "SUMSUE" wrote in message ... I've typed in this formula to count the number of items that are within the range that is more than 30 but less than 61 looking at one column with different values, =COUNTIF(N2:N8000,"<3161") I've done one for less than 31 and it works but can't add the second criteria. It should return a value of 98 but I keep getting 0. Where am I going wrong? Thanks in advance |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Greater and less than
shouldn't your formula be <31 and 61? not an expert by any means.
-- Thanks! Lonnie Jo "SUMSUE" wrote: I've typed in this formula to count the number of items that are within the range that is more than 30 but less than 61 looking at one column with different values, =COUNTIF(N2:N8000,"<3161") I've done one for less than 31 and it works but can't add the second criteria. It should return a value of 98 but I keep getting 0. Where am I going wrong? Thanks in advance |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Greater and less than
try this
=COUNTIF(N:N,"<60")+COUNTIF(N:N,"30")-COUNT(N:N) On Jul 10, 2:35*am, SUMSUE wrote: I've typed in this formula to count the number of items that are within the range that is more than 30 but less than 61 looking at one column with different values, =COUNTIF(N2:N8000,"<3161") I've done one for less than 31 and it works but can't add the second criteria. It should return a value of 98 but I keep getting 0. Where am I going wrong? Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Greater Than and less than HELP PLEASE | Excel Discussion (Misc queries) | |||
| if greater than? | Excel Worksheet Functions | |||
| greater than but less than | Excel Discussion (Misc queries) | |||
| IF greater than Zero | Excel Worksheet Functions | |||
| IF greater than...IF less than....====== | Excel Discussion (Misc queries) | |||
Linear Mode
