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.

Please Login or Register  to view this content.

[wk9128]

Cell P2 formula , Drag down

Please Login or Register  to view this content.

[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.