| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count if
I have numbers in A1:A100, lets say 1 - 100. I also have a number in C11 and
a number in E11. How do I get a count of how many numbers in A1:A100 fall between C11 and E11? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count if
Try this formula if "between" meant not to count the values in C11 and
E11... =SUMPRODUCT((A1:A100C11)*(A1:A100<E11)) Try this formula if "between" meant to include them... =SUMPRODUCT((A1:A100=C11)*(A1:A100<=E11)) -- Rick (MVP - Excel) "BC" wrote in message ... I have numbers in A1:A100, lets say 1 - 100. I also have a number in C11 and a number in E11. How do I get a count of how many numbers in A1:A100 fall between C11 and E11? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count if
Thanks Rick, just what I needed
"Rick Rothstein" wrote: Try this formula if "between" meant not to count the values in C11 and E11... =SUMPRODUCT((A1:A100C11)*(A1:A100<E11)) Try this formula if "between" meant to include them... =SUMPRODUCT((A1:A100=C11)*(A1:A100<=E11)) -- Rick (MVP - Excel) "BC" wrote in message ... I have numbers in A1:A100, lets say 1 - 100. I also have a number in C11 and a number in E11. How do I get a count of how many numbers in A1:A100 fall between C11 and E11? Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count if
But what if 2 or more of the numbers in A1:A100 are the same?
"Rick Rothstein" wrote: Try this formula if "between" meant not to count the values in C11 and E11... =SUMPRODUCT((A1:A100C11)*(A1:A100<E11)) Try this formula if "between" meant to include them... =SUMPRODUCT((A1:A100=C11)*(A1:A100<=E11)) -- Rick (MVP - Excel) "BC" wrote in message ... I have numbers in A1:A100, lets say 1 - 100. I also have a number in C11 and a number in E11. How do I get a count of how many numbers in A1:A100 fall between C11 and E11? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Linear Mode
