Forum Discussion

Nagendra PrasadBS's avatar
Nagendra PrasadBS
Copper Contributor
Oct 03, 2017

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

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