Need to countif query

[Dazzybeeguy]

I want to create a spreadsheet with a Table as follows

A2 = Start Date i.e 1st Jan 2023
B2 = End Date i.e 31st Dec 2023
C2 = Persons Name Bob ( Data Validation list)
D2 would then have the Formula


So lets assume Column H2:H1000 is a long list of dates
Column I2:I1000 is a list of people

So I want a formula that will tell me how many times Bobs name appears in the date period from A2 to B2

I hope my explanation makes sense.

Is this some kind of countif or sumif type formula

Thanks

 

[johnny51981]

Give this a shot:

=COUNTIFS($H$2:$H$1000,">="&$A2,$H$2:$H$1000,"<="&$B2,$I$2:$I$1000,$C2)

 

[Dazzybeeguy]

Give this a shot:

=COUNTIFS($H$2:$H$1000,">="&$A2,$H$2:$H$1000,"<="&$B2,$I$2:$I$1000,$C2)

Thanks, so easy when its in front of you, save me some head scratching