Excel Formula Question

  • Thread starter Thread starter Steven Page
  • Start date Start date
S

Steven Page

Hi there.

I need to figure out how many items in a column fall between a certain
range.

I have a list of 354 numbers, and I want to find how many cells contain
numbers between 1000 and 10000, and return that number to me.

I have explored the help and on-line resources, but cannot find an answer to
this. Can anyone help?

Thanks

Steve Page
 
Hi,

Assuming that your list is in Column A:

=SUMPRODUCT((A1:A100>1000)*(A1:A100<10000))

Adjust the range according to your data.

Hope this helps
 
Back
Top