Using countifs with date range, and summing values in that range

Greetings,

New to the forum and this is my first post so hopefully I don't muck it up too bad

I have a sheet that has a column with a number of days an issue took, if that issue is still open. If the issue is closed, the column will be blank. I am looking to populate cells, based on a date range, that fall into the following categories:

Total Issues for Month Still Open Open 0-28 Days Open 29-50 Days Open 50+ Days

=COUNTIF('2013 Data'!B1:B600,">=08/01/13")-COUNTIF('2013 Data'!B1:B600,">08/31/13") is what I used to count the total number of issues for any given month which works fine.

What I would like to do is count how many items within the date range, fall into those categories so the table would look like this:

Capture.JPG


This is Excel 2010 so I believe that I could use =COUNTIFS but I'm having a hard time with the syntax.

Column B contains dates
Column R is the total number of days that an issue was opened.

Thanks in advance for any help you can lend.

Brian

pls post a sample of the workbook

Try something like this...


Data Range

	A	B	C	D	E	F	G	H
1	Date	Days				0	29
2	2/23/2013	82			Month	28	50	51
3	2/2/2013	59			1/1/2013	0	2	0
4	2/28/2013	37			2/1/2013	0	1	2
5	2/26/2013				3/1/2013	0	1	2
6	3/4/2013	63
7	3/18/2013	32
8	3/9/2013	61
9	1/29/2013	29
10	1/13/2013	34

Enter this formula in F3:

=COUNTIFS($A$2:$A$10,">="&$E3,$A$2:$A$10,"<="&EOMONTH($E3,0),$B$2:$B$10,">="&F$1,$B$2:$B$10,"<="&F$2)

Copy across to G3.

Enter this formula in H3:

=COUNTIFS(A$2:A$10,">="&$E3,A$2:A$10,"<="&EOMONTH($E3,0),B$2:B$10,">="&H$2)

Select F3:H3 and copy down as needed.

Good deal. Thanks for the feedback!