I have a large spreadsheet with several sheets. Sheet1-Sheet5, have data running across horizontally on every other column (a1, c1, e1, etc.). On Sheet6, cell A1, I need to calculate the sum of A1 on all previous sheets. However, I need to drag the formula down so that A2 calculates the sum of C1 on all previous sheets, A3=sum of E1, and so on. I believe I need to use the Indirect function but I'm not familiar enough with it to get it formatted correctly.
Thanks in advance!
Thanks in advance!