According to fuzzy query and select this month plus the sum of the previous month

[metrostar]

example

When P1 selects the month, the A column should correspond to the G column, and the sum of the month P1 plus the previous month should be counted.

Cell P2 result should be =SUM(K2,K3,J2,J3)

Any help would be appreciated!

[Crooza]

Try this in P2. You can use the logic in this one for the remainder of the yellow highlighted cells.

=SUM(OFFSET(A2,0,MATCH($P$1,$B$1:$M$1,0)),OFFSET(A3,0,MATCH($P$1,$B$1:$M$1,0)),OFFSET(A2,0,MATCH($P$1,$B$1:$M$1,0)-1),OFFSET(A3,0,MATCH($P$1,$B$1:$M$1,0)-1))

[wk9128]

Cell P2 formula , Drag down

=SUM(SUMIF(A:A,"*"&$O2&"*",OFFSET(A:A,,MATCH(P$1,$B$1:$M$1,)+{-1;0})))

[metrostar]

Thank you @Crooza , your formula doesn't do what I want

@wk9128 you are amazing, just what i wanted, thank you

[wk9128]

@metrostar You're Welcome. Glad to help . Thank You for the feedback.