Dear Forum Friends,
I have tried below formula but it is not working what I need to get , may be I may doing mistake some where , please correct any one
it should sum up with in the particular months only
like Oct18 to Sep19 only , not total row or previous (Nov17- Sep 18) or next (oct19-sep-20)
sheet attached for your reference
please help
Thank you in advance
Regards
SUDARSAN
I have tried below formula but it is not working what I need to get , may be I may doing mistake some where , please correct any one
=SUMIF($S$1:$DV$1,"<="&$C2,INDEX($S$2:$DV$324,MATCH($A2,$R$2:$R$324,0),0))
it should sum up with in the particular months only
like Oct18 to Sep19 only , not total row or previous (Nov17- Sep 18) or next (oct19-sep-20)
sheet attached for your reference
please help
Thank you in advance
Regards
SUDARSAN
Attachments
Last edited by a moderator: