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?


[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Broken[/TD]
[TD]Repaired[/TD]
[TD]Damaged[/TD]
[/TR]
[TR]
[TD]2015-10-01
[/TD]
[TD]1[/TD]
[TD]6[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]2015-10-02[/TD]
[TD]2[/TD]
[TD]7[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2015-10-03[/TD]
[TD]3[/TD]
[TD]9[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2015-11-01[/TD]
[TD]4[/TD]
[TD]8[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]2015-11-04[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]











Results in:

[TABLE="class: grid, width: 300, align: left"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Tot Repaired[/TD]
[TD]Tot Damaged[/TD]
[/TR]
[TR]
[TD]October[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]November[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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