Formula to summarize multiple values based on two cell values and column values

[Nagendra PrasadBS]

Hello,
I wanted to get the summarized value for each branch 3months pre and 3months post based on branch date_moved for each branch as per the below values in excel.

I have tried using Sumifs with multiple value criteria but it's not working. Please help me out to crack the criteria.

Thanks in advance.

Prasad

[#2]

That's here https://techcommunity.microsoft.com/t5/Formulas-and-Functions/Formula-to-summarize-multiple-values-b...