I have set up a formula to sum data from specific columns in multiple sheets in the same file. The simple formula had worked perfectly until I needed the data from the last sheet. In all of the other sheets the data that I need to pull is all in consecutive rows but in the last sheet the data that I need pulled and added is in every 4th row. The sheet looks like this:
All of the columns I've filled in work fine. The ones blank are the ones I am running into issues with. When I drag down the formulas excel pulls the next consecutive rows, which is perfect for the first four sheets I am summing, but for the fifth sheet (I'll ref the Test1 column) I need it to pull 'Wayne 2014'!C6 and then 'Wayne 2014'!C10 in the next row and so forth.
<tbody>
</tbody>
The first four sheets look like this, which is why they work fine:
<tbody>
</tbody>
The fifth sheet looks like this:
I only want the formulas from the first sheet to pull the data from the dated rows in this sheet.
<tbody>
</tbody>
Is there any way in Excel 2010 to get it do what I want?
I apologize if I have given unnecessary information. I am horrible at explaining things and am new to the forum but I wanted to make sure everything was clear.
Any help would be appreciated.
Thank you!
Vi
(I am not sure how that one cell became outlined and I do not know how to fix it. Sorry if that confused anything.)
All of the columns I've filled in work fine. The ones blank are the ones I am running into issues with. When I drag down the formulas excel pulls the next consecutive rows, which is perfect for the first four sheets I am summing, but for the fifth sheet (I'll ref the Test1 column) I need it to pull 'Wayne 2014'!C6 and then 'Wayne 2014'!C10 in the next row and so forth.
Date | All Test | Test1 | Test2 | Test3 | Test4 | $ Amt. |
Jan.16 | =SUM(C2+D2+E2+F2) | =SUM('Gennessee 2014'!C2+'Kalamazoo 2014'!C2+'Kent 2014'!C2+'Oakland 2014'!C2+'Wayne 2014'!C2) | =SUM('Gennessee 2014'!D2+'Kalamazoo 2014'!D2+'Kent 2014'!D2+'Oakland 2014'!D2+'Wayne 2014'!D2) | =SUM('Kalamazoo 2014'!E2) | =SUM('Gennessee 2014'!E2+'Kalamazoo 2014'!F2+'Kent 2014'!E2+'Oakland 2014'!E2+'Wayne 2014'!E2) | =SUM('Gennessee 2014'!F2+'Kalamazoo 2014'!G2+'Kent 2014'!F2+'Oakland 2014'!F2+'Wayne 2014'!F2) |
Jan.31 | =SUM(C3+D3+E3+F3) | |||||
Feb.16 | =SUM(C4+D4+E4+F4) |
<tbody>
</tbody>
The first four sheets look like this, which is why they work fine:
Date | All Test | Test1 | Test2 | Test3 | $ Amt. |
Jan. 16 | =SUM(C2:E2) | 1 | 1 | 1 | $1 |
Jan. 31 | =SUM(C3:E3) | 1 | 1 | 1 | $1 |
Feb. 1 | =SUM(C4:E4) | 1 | 1 | 1 | $1 |
<tbody>
</tbody>
The fifth sheet looks like this:
I only want the formulas from the first sheet to pull the data from the dated rows in this sheet.
Date | All Test | Test1 | Test2 | Test3 | $ Amt. | |
Jan. 16 | =SUM(C2:E2) |
<tbody> </tbody> | =SUM(D3:D5) | =SUM(E3:E5) | =SUM(F3:F5) | |
Div.1 | =SUM(C3:E3) | 1 | 1 | 1 | $1 | |
Div.2 | =SUM(C4:E4) | 1 | 1 | 1 | $1 | |
Div.3 | =SUM(C5:E5) | 1 | 1 | 1 | $1 | |
Jan.31 | =SUM(C6:E6) | =SUM(C7:C9) | =SUM(D7:D9) | =SUM(E7:E9) | =SUM(F7:F9) | |
Div.1 | =SUM(C7:E7) | 1 | 1 | 1 | $1 | |
Div.2 | =SUM(C8:E8) | 1 | 1 | 1 | $1 | |
Div.3 | =SUM(C9:E9) | 1 | 1 | 1 | $1 | |
Feb.1 | =SUM(C10:E10) | =SUM(C11:C13) | =SUM(D11:D13) | =SUM(E11:E13) | =SUM(F11:F13) | |
Div.1 | =SUM(C11:E11) | 1 | 1 | 1 | $1 | |
Div.2 | =SUM(C12:E12) | 1 | 1 | 1 | $1 | |
Div.3 | =SUM(C13:E13) | 1 | 1 | 1 | $1 |
<tbody>
</tbody>
Is there any way in Excel 2010 to get it do what I want?
I apologize if I have given unnecessary information. I am horrible at explaining things and am new to the forum but I wanted to make sure everything was clear.
Any help would be appreciated.
Thank you!
Vi
(I am not sure how that one cell became outlined and I do not know how to fix it. Sorry if that confused anything.)