Snasui Excel Forum

Hi there!

I have an issue with formula sum values base on month criteria.sum from the start month to month as variable.
In this example I sum base on Feb .it sums from Jan to Feb but the result not I need .it should 3 not 4.


TY

I think you want the formula like this,

C5 =SUMIFS(OFFSET(A2,0,0,1,MATCH(B5,1:1,0)),OFFSET(A1,0,0,1,MATCH(B5,1:1,0)),"<>")

TY