Sum function with match months and add columns

Hi All,

I thought i have well explained my query in the attached sheet.
Please help. Thanks in advance.

Regards,
Suresh

Hi Suresh,

Try using below formula:-

Formula:

=SUM(OFFSET($B3,0,MATCH(K$2,$C$2:$I$2,0),1,$B3))

see attached:- Book1(50).xlsx


Regards,
DILIPandey
<click on below * if this helps>

hi Suresh, some other alternatives:
=SUMIFS($C3:$I3,$C$2:$I$2,">="&K$2,$C$2:$I$2,"<="&EOMONTH(K$2,2))
=SUMPRODUCT($C3:$I3,($C$2:$I$2>=K$2)*($C$2:$I$2<=EOMONTH(K$2,2)))

You are welcome Suresh..

cheers


Regards,
DILIPandey
<click on below * if this helps>