Count values on a specific date with criteria

[ronakchaudhary]

hi

please help me on below query.

i have table that contains dates & another column have values from that table i want to make table that shows that on perticuler date how much count between two values. example mention below

date Number
01/09/2019 1
04/09/2019 2
02/09/2019 3
01/09/2019 4
04/09/2019 2
01/09/2019 1
04/09/2019 5
02/09/2019 2
01/09/2019 2
04/09/2019 2
01/09/2019 3
04/09/2019 4
02/09/2019 5
01/09/2019 1
04/09/2019 2
01/09/2019 3
04/09/2019 3
02/09/2019 4
01/09/2019 2
04/09/2019 2

from this table i want the result for example i that on 1/09/2019 how much count between 2>=<5

please help me

[Olly]

You could use COUNTIFS:

Please Login or Register  to view this content.

[ronakchaudhary]

how can i take range value from cell

[Glenn Kennedy]

Rule 01: Thread Titles

Hi. We'd like to help... but.

Your thread title is VERY weak. It should resemble the terms you would use if you were searching Google for an answer. Your title would produce a squillion useless hits.

So... Please take a moment to amend your thread title. Make sure that the title properly explains your request. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.


But. You are new here, so I have changed your title for you, on this occasion. However, if you continue to use weak titles, you can expect your thread to be LOCKED until YOU make the required changes.

[Glenn Kennedy]

Try:
=COUNTIFS(A:A,F1,B:B,">2",B:B,"<5")