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