Monthwise Data to come in one column

Please help to get data for all months in YTD cloumn and monthly data in Month Column like Apr'16.

In cell N3 enter {=SUM(IF($A$3:$A$14=$L3,IF($B$3:$B$14=$M3,$D$3:$G$14)))}

In cell O3 enter {=SUM(IF($A$3:$A$14=$L3,IF($B$3:$B$14=$M3,IF($C$3:$C$14=$O$2,$D$3:$G$14))))}

IMPORTANT - These are array formulae, so you need to press Ctrl+Shift+Enter after pasting the formula in (or after editing) to get the curly braces.

Thanks just one help if i want only kcc or lhp or hhp or mhp then what will be the formula.

Not sure which one of us you are responding to, but...

Originally Posted by nits1982

Thanks just one help if i want only kcc or lhp or hhp or mhp then what will be the formula.

If you only want to sum a single column it's much easier...

In cell N3 enter =SUMIFS($D$3:$D$14,$A$3:$A$14,$L3,$B$3:$B$14,$M3)

In cell O3 enter =SUMIFS($D$3:$D$14,$A$3:$A$14,$L3,$B$3:$B$14,$M3,$C$3:$C$14,$O$2)

Replace the first range with whichever column you want to sum.

These are not now array formulae, so you do not need the curly braces.

Thanks to EchoPassenger