Monthwise Data to come in one column

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.