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!

 

[Fluff]

In that case use

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

and drag it down.

 

[msvoboda27]

I removed the formula from the cells, can you please tell me what needs to happen to get this resolved.
Thank you,
Michael

 

[Fluff]

Did you try what I suggested in post#11?

 

[msvoboda27]

I removed the cells as suggested but it didn't change the excel error of spills. Help please

 

[Fluff]

That is not what I said in post#11.

 

[msvoboda27]

Hi! I apologize sincerely; I didn't realize there was a 2nd page until just now. Yes, I did what you said in post #11 and used the copy function. Here are the results. Once again, I'm so sorry for my mistake.

 

[Fluff]

In that case can you post a sample of your data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[msvoboda27]

HI
I am not able to download at my work I will have to do it any home home pc.
Thanks

 

[Fluff]

Ok .
One thing I noticed is that col C has both date & time, so you will need a slight tweak to the formula

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