Formulas not working when dragged down rows

[slstewart249]

I am trying to sum monthly columns into Quarter columns . In row 2, I entered the sum formulas and it worked. I then dragged the formulas down the row 8. Strangely in some rows the formula works (3,4,5) but then starting with row 6 it reverts back to showing the same results as row 2, which is incorrect

I've never seen anything like this before. How can I get the formulas to work correctly?



1 Q1 Q2 Q3 Q4 2,018
2 - 45 50 50 145
3 - - 750 - 750
4 48 32 24 44 148
5 48 77 824 94 1,043
6 - - 750 - 750
7 - - 750 - 750
8 - - 750 - 750

 

[GraH - Guido]

Please upload your workbook. Without seeing the formula, it is difficult to say what is wrong.
Wild guess: are you using relative/absolute references?

 

[slstewart249]

Actually I think it is because of scenarios. I am trying to sum quarters for three different scenarios. The scenarios are linked to another tab where I have to select an number for the scenarios (1 for scenario 1, 2 for scenario 2, 3 for scenario 3). It is only showing sums for one scenario at a time and I need to list down by rows a summary by qtr for each of the three scenarios. I cant upload a company excel file.

 

[GraH - Guido]

Actually you can always anonymize the workbook and use dummy data... See the forum rules, sample files are essential in cases like yours. Difficult to suggest any formula without seeing data structure, sheet names,...
From what I understand from your reply, you could more easily consolidate all information of different tabs via Power Query. Just with a few mouse clicks.
Depending on the Excel version you have, that might be the right thing to do.
Perhaps it can also be done via a pivot on multiple ranges. Or even with the built in consolidate.