Count if

[BC]

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

 

[Rick Rothstein]

Try this formula if "between" meant not to count the values in C11 and
E11...

=SUMPRODUCT((A1:A100>C11)*(A1:A100<E11))

Try this formula if "between" meant to include them...

=SUMPRODUCT((A1:A100>=C11)*(A1:A100<=E11))

 

[BC]

Thanks Rick, just what I needed

Try this formula if "between" meant not to count the values in C11 and
E11...

=SUMPRODUCT((A1:A100>C11)*(A1:A100<E11))

Try this formula if "between" meant to include them...

=SUMPRODUCT((A1:A100>=C11)*(A1:A100<=E11))

 

[BC]

But what if 2 or more of the numbers in A1:A100 are the same?