SUMIF or SUMPRODUCT or any formula for this data set?

Hi Experts! Needing some help here with my subpar formula skills.

With a data set like this,

Date	Category	Hours	Complete
1/1/2016	A	8	Yes
4/1/2016	B	1	Yes
4/1/2016	B	1	Yes
4/1/2016	B	4	Yes
5/1/2016	C	5	No
5/1/2016	D	0.5	Yes
5/1/2016	E	0.5	Yes
5/1/2016	E	2	Yes
5/1/2016	F	1.5	No

What formula can be used, if I do not want any helper columns/rows nor do I want to use a pivot table, to achieve this aggregate table?

Hours are summed, grouped by category on Rows, grouped by months on Columns, where complete = Yes

Category	Jan	Feb	YTD
A	8	0	8
B	6	0	6
C	0	0	0
D	0.5	0	0.5
E	2.5	0	2.5
F	0	0	0
Total	17	0	17

I can achieve it with a pivot table but the labels (text in cells, e.g. "YTD" and "Total") on the pivot table are not very customizable.

Thanks!

If you have dataset A1:D10

Try

F2=IFERROR(INDEX($B$2:$B$10,MATCH(0,INDEX(COUNTIFS($F$1:F1,$B$2:$B$10),),0)),"") and drag down.

G2=SUMPRODUCT((TEXT($A$2:$A$10,"mmm")=G$1)*($B$2:$B$10=$F2)*($D$2:$D$10="Yes")*($C$2:$C$10)) and drag towards the cells and down.

Check the attached file.

Thank you both Ankur and John! Maybe not to you, but they are both very impressive solution to me!