countifs function with date range

[msvoboda27]

Hello,

I have a large data table with "create date" and "status" fields. How can I count the number of statuses within a date range using cell references?
Specifically, I would like to count the number of "closed," "resolved," etc. statuses from the date range specified in cells D2 through E2. I will need to update the values in row 2 with the new date range next month.
Thank you!

 

[6StringJazzer]

Show us the data you want to count. Also better to post the actual data instead of a screenshot.

 

[Eric W]

Something like:

=COUNTIFS($G$1:$G$100,D3,$H$1:$H$100,">="&$D$2,$H$1:$H$100,"<="&$E$2)

assuming your status is in range $G$1:$G$100 and the date is in $H$1:$H$100. Put that formula in E3 and drag down.

 

[msvoboda27]

Hello
Below is the table of data I like to have count by status
.

 

[msvoboda27]

Hi, Can someone please look at this request now that I added an excel table? Thank you

 

[Eric W]

My previous formula will work fine. Here it is adjusted to your ranges:

=COUNTIFS($B$11:$B$100,D3:D6,$C$11:$C$100,">="&$D$2,$C$11:$C$100,"<="&$E$2)

Put this in E3. I made it a Spill formula so you don't need to drag it down. Change the bottom row (100 in this formula) to whatever your actual bottom row is.

 

[msvoboda27]

Hello,

Thank you once again for your response.

I diligently used the formula you provided to update the file, but I kept encountering the "Spill" error. I confirmed that the create date field is indeed a date field, and I have included a screenshot for your reference.
Additionally, I ensured that all 100 rows had no missing data in any of the cells. I am using MS Excel 365
What am I missing?

 

[Phuoc]

...

 

[Fluff]

Clear the cells E4, E5 & E6 just leaving the formula in E3

 

[msvoboda27]

I removed the formulas in cells E4, E5, E6, I continue to get the spill error. I have to be doing something wrong but unsure what.

Here is the spill error