| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to count a set of numbers in a range
I have a range of numbers, I3:I52 that contain percentages.
I need to count the number of cells that are between 9% and 11%. I have tried multiple COUNTIF statements but that doesn't seem to work. Any help is appreciated. -- thanks, Dave |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to count a set of numbers in a range
On Sep 11, 12:08*pm, DaveC wrote:
I have a range of numbers, I3:I52 that contain percentages. I need to count the number of cells that are between 9% and 11%. I have tried multiple COUNTIF statements but that doesn't seem to work. Any help is appreciated. -- thanks, Dave This is how to do it with Count if. =COUNTIF(A1:A10,"<="&.11)-COUNTIF(A1:A10,"<="&.09) Here is how to do it with Sumproduct =SUMPRODUCT((A1:A10<=.11)*(A1:A10=.09)*(1)) Jay |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to count a set of numbers in a range
On Sep 11, 12:16*pm, jlclyde wrote:
On Sep 11, 12:08*pm, DaveC wrote: I have a range of numbers, I3:I52 that contain percentages. I need to count the number of cells that are between 9% and 11%. I have tried multiple COUNTIF statements but that doesn't seem to work. Any help is appreciated. -- thanks, Dave This is how to do it with Count if. =COUNTIF(I3:I52,"<="&.11)-COUNTIF(I3:I52,"<="&.09) Here is how to do it with Sumproduct =SUMPRODUCT((I3:I52<=.11)*(I3:I52=.09)*(1)) Jay This is with your range. This is how to do it with Count if. =COUNTIF(I3:I52,"<="&.11)-COUNTIF(I3:I52,"<="&.09) Here is how to do it with Sumproduct =SUMPRODUCT((I3:I52<=.11)*(I3:I52=.09)*(1)) Jay |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to count a set of numbers in a range
=SUMPRODUCT((I3:I52=0.09)*(I3:I52<=0.11))
so for data like: 19.00% 1.00% 18.00% 6.00% 6.00% 8.00% 11.00% 10.00% 19.00% 12.00% 9.00% 3.00% 8.00% 19.00% 5.00% 18.00% 6.00% 3.00% 12.00% 18.00% 5.00% 13.00% 18.00% 16.00% 3.00% 9.00% 13.00% 12.00% 3.00% 20.00% 11.00% 2.00% 4.00% 6.00% 9.00% 7.00% 19.00% 2.00% 20.00% 11.00% 7.00% 9.00% 15.00% 13.00% 10.00% 5.00% 6.00% 10.00% 18.00% 8.00% the formula yields 10 -- Gary''s Student - gsnu200903 "DaveC" wrote: I have a range of numbers, I3:I52 that contain percentages. I need to count the number of cells that are between 9% and 11%. I have tried multiple COUNTIF statements but that doesn't seem to work. Any help is appreciated. -- thanks, Dave |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to count a set of numbers in a range
Excel 2007 -
=COUNTIFS(I3:I52,"=.09",I3:I52,"<=.11") -- If this post helps click Yes --------------- Peggy Shepard "jlclyde" wrote: On Sep 11, 12:16 pm, jlclyde wrote: On Sep 11, 12:08 pm, DaveC wrote: I have a range of numbers, I3:I52 that contain percentages. I need to count the number of cells that are between 9% and 11%. I have tried multiple COUNTIF statements but that doesn't seem to work. Any help is appreciated. -- thanks, Dave This is how to do it with Count if. =COUNTIF(I3:I52,"<="&.11)-COUNTIF(I3:I52,"<="&.09) Here is how to do it with Sumproduct =SUMPRODUCT((I3:I52<=.11)*(I3:I52=.09)*(1)) Jay This is with your range. This is how to do it with Count if. =COUNTIF(I3:I52,"<="&.11)-COUNTIF(I3:I52,"<="&.09) Here is how to do it with Sumproduct =SUMPRODUCT((I3:I52<=.11)*(I3:I52=.09)*(1)) Jay |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Numbers Only Once in a Range | Excel Discussion (Misc queries) | |||
| Count unique numbers in a range with a given criteria | Excel Discussion (Misc queries) | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
| get a count of numbers whose value falls within a given range | Excel Worksheet Functions | |||
| How do I count numbers in a range that are greater than and less . | Excel Worksheet Functions | |||
Linear Mode
