Finding the number of cells from a range.

[Excel-newbie-in-need]

I have to find the number of cells than contain a number within 900-1000 in an excel table that contains values from 0 to 2000 randomly aligned within a column.

I have tried using =COUNTIF(B2:B5,">=32")-COUNTIF(B2:B5,"<=85"), which is the general formula for those matters, but it does not give the correct answer....

Any ideas/alternatives?

[6StringJazzer]

I do not see why you expect criteria between 32 and 85 to give you numbers between 900-1000.

Your table only has three rows?

Please Login or Register  to view this content.

If this does not work for you please attach a sample file with a sample result. See yellow banner at the top of the page.

[Excel-newbie-in-need]

My apologies, the values I have placed were copy-pasted from the example I wrote-down for reference.

Thank you for your help, it does work with the formula you gave me, but I ran into another problem... I have to get the info from a different sheet...and if I use:

=COUNTIFS(Sheet1!B2:B5,">="&900,B2:B5,"<="&1000) it does not get the info from the first sheet.

Any idea what I'm doing wrong?

[6StringJazzer]

You use the sheet reference everywhere.

Please Login or Register  to view this content.