Forum Discussion
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
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
- Have a play with
=INDEX(G$4:G$14,MATCH(G$2,F$4:F$14,1)-1)+INDEX(G$4:G$14,MATCH(G$2,F$4:F$14,1)-2)+INDEX(G$4:G$14,MATCH(G$2,F$4:F$14,1)-3)
the f$4;f$15 is where the year/Month and F$4 is where the move date year/month
I would go with working out the match part first also try year*100+ month as a number
