Count if

  • Thread starter Thread starter BC
  • Start date Start date
B

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
 
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))
 
Thanks Rick, just what I needed

Rick Rothstein said:
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))
Click to expand...
 
Back
Top