Sum a range of values depending on which month it is. (SUMIF?)

[Darkzler]

Hello everyone,

Got a new issue which I can't really get to work.

I have the following:

Dates in column A
Repaired items in column C
Damaged items in column D

I want a table that summarizes repaired and damaged items depending on which month it has been added.

For examples, ten entries in january, then I want a cell that contains the total of januaries damaged and repaired items.

I tried using SUMIF and an IF statement but failed. Anyone who can assist me?

Date	Broken	Repaired	Damaged
2015-10-01	1	6	2
2015-10-02	2	7	3
2015-10-03	3	9	4
2015-11-01	4	8	5
2015-11-04	5	1	5

<tbody>
</tbody>

Results in:

Month	Tot Repaired	Tot Damaged
October
November

<tbody>
</tbody>

 

[Comfy]

Excel 2010
	A	B	C	D
1	Date	Broken	Repaired	Damaged
2	01/10/2015	1	6	2
3	02/10/2015	2	7	3
4	03/10/2015	3	9	4
5	01/11/2015	4	8	5
6	04/11/2015	5	1	5
7
8
9
10
11
12
13
14
15	Month	Repaired	Damaged
16	October	22	9
17	November	9	10
Sheet1

Cell Formulas
Range	Formula
B16	=SUMIFS(INDEX($B$2:$D$6,,MATCH(B$15,$B$1:$D$1,0)),$A$2:$A$6,">="&$A16,$A$2:$A$6,"<="&EOMONTH($A16,0))

The months in the Summary Table are actually the first day of the month formatted as "MMMM" e.g. 01/10/15 = October

Or use a pivot table.

Row Labes = "Date"
Values = "Broken column" & "Repaired column"

Group the dates my Month and year.

Excel 2010
	A	B	C	D
2
3	Row Labels	Sum of Repaired	Sum of Damaged
4	2015
5	Oct	22	9
6	Nov	9	10
7	Grand Total	31	19
Sheet4