Snasui Excel Forum

Hi Dear


I have a problem for summing up sales from a month to month.I try with sumifs but no luck

Is there any workaround to resolve this?

I attached a sample

Thanks

Please try,

P5 =SUM(INDEX(B3:M14,MATCH(P2,A3:A14,0),MATCH(P3,B2:M2,0)):INDEX(B3:M14,MATCH(P2,A3:A14,0),MATCH(P4,B2:M2,0)))

Another type
P5=SUM(P3:OFFSET(P4,,,MATCH(P4,B2:M2,)))

Thanks but this is not working P5=SUM(P3:OFFSET(P4,,,MATCH(P4,B2:M2,)))

sna wrote: Fri Feb 19, 2021 4:54 pm Thanks but this is not working P5=SUM(P3:OFFSET(P4,,,MATCH(P4,B2:M2,)))

Try it
P3=SUM(OFFSET(A2,MATCH(P2,A3:A14,),MATCH(P3,B2:M2,),,MATCH(P4,B2:M2,)-MATCH(P3,B2:M2,)+1))