Count qty between ranges

[Headmore]

I have a range of number from 159 to 300. i would like to have a formula that would tell me how many number are between 200 and 225, 226 and 250, and 251 and 300.

thank you very much

[FDibbins]

Hi and welcome to the forum

We would love to help you with your question, but 1st, in accordance with forum rule, please rename your thread to something more meaningful, that actually describes your problem.

Because thread titles are used in searching the forum it is vital they be written to accurately describe your thread content or overall objective using ONLY search friendly key words. That is, your title used as search terms would return relevant results.

Also, many members will look at a thread title, and if it is of interest to them, or it falls within their area of expertese, they might only open those threads.

Look at it this way...if you typed that title into google, what would you expect to get back?
To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title

[Headmore]

Sir, I am not trying to be funny, but that is my problem, I am a novice at this, all I know is some of the basic.
this is my first time using this forum. maybe you can suggest what to change it to.

[FDibbins]

I have changed it for you

Try this, and change the crieria for each range...
=COUNTIFS(A1:A10,">=200",A1:A10,"<=225")

[oeldere]

with pivot table and grouping.

see the attached file.

[Headmore]

I tired that it but didn't work.

[oeldere]

@headmore

Please reply to whom you responding.

Please Login or Register  to view this content.

=> it's I'm tired or do you mean I tried

[Headmore]

I mean I tried, sorry about that.

[oeldere]

You don't give an answer which solution won't work.

[FDibbins]

i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[Headmore]

see attached

[Headmore]

I have attached a sample work book

[FDibbins]

If Im looking in the right place (B10?), then...
=COUNTIFS(C16:E33,">=200",C16:E33,"<=225") (you had 250 instead of 225?)

[FDibbins]

And your next formula needs to be
=COUNTIF(C16:E33,">225")
not
=COUNTIF(C16:E33,">=225")
otherwise you will be including 225 twice - so pick which range you want it in?

[Headmore]

I tried 225, 250 and it still return a 0

[FDibbins]

I used my formula in post 14 and they

You have...
=COUNTIFS(C16:E33,"=>200,C16:E33,"<="250")
compare that to the formula I gave you...
=COUNTIFS(C16:E33,">=200",C16:E33,"<=225")
Mine gives an answer of 15