Sum Values in a Table Matching Specific Row and Column Values

Ford,

Thanks so much for the help! I typically do keep the headings the same but unfortunately this report that is generated is in one of our financial systems and it doesn't allow us to modify the outputs for the periods. So, I have to work with the "001/2014" format but I don't want to show periods in my summary since there are 16 financial periods in a year. So, with that being said...will the formulas below work with the outputs that I have to work with? Also, could you explain the use of OFFSET in this scenario and why it's beneficial? Thanks!

Dustin

Originally Posted by FDibbins

Hi and welcome to the forum

1 of the 1st things you need to learn, is keep your headings in the same format wherever possible. For instance in Summary, you have actual dates (which are numeric), but on Report, you have just text. Then you can use this for the 1st column...
=SUMIF(Report!$A$4:$A$39,Summary!B$1,OFFSET(Report!$G$4,0,MATCH($A2,Report!$G$2:$R$2,0)-1,COUNTA(Report!A:A)-1,1))
and this for the "others"
=SUM(OFFSET(Report!$G$4,0,MATCH($A2,Report!$G$2:$R$2,0)-1,COUNTA(Report!A:A)-1,1))-B2