Matching month amounts

Hi

I'm kindly asking for a formula for cell F8. I want that if cell C5 is January 2021, then cell F8 matches the amount on cell i2 in the "DATABANK SHEET",
and then if cell C5 is February 2021 then the cell F8 matches the amount on the cell i3 and so on.

Thank you.

Regards,

Sunboy

How about

Formula:

Please Login or Register  to view this content.

Bank


f9=sumif(databank!h2:h13,bank!c6,databank!i2:i13)

Hi CARACALLA

Thank you for the formula.

Regards,

Sunboy