Hello,
I am currently working on a spreadsheet that looks somewhat like this:
<tbody>
</tbody>
My question is this: I need the "Store" & "Case" columns to be every other and I need the sum of each. However, I also need to be able to delete an entire column. So, of course when I delete columns I get a reference error. I tried using Indirect =SUM(INDIRECT("B2"),INDIRECT("D2"),INDIRECT("F2")) so I could delete them but then it moves the total columns into the columns that are being added and causes issues. Is there a way to do this?
Hopefully I am explaining this well enough.
Thank you very much!
Mandy
I am currently working on a spreadsheet that looks somewhat like this:
Column A | Column B | Column C | Column D | Column E | Column F | Column G | Column H | Column I |
Item # | Store 1 Units | Store 1 Cases | Store 2 Units | Store 2 Cases | Store 3 Units | Store 3 Cases | Total Units | Total Cases |
123 | 50 | 2 | 25 | 1 | 75 | 3 | =SUM(B2,D2,F2) | =SUM(C2,E2,G2) |
456 | 25 | 1 | 25 | 1 | 50 | 2 | =SUM(B3,D3,F3) | =SUM(C3,E3,G3) |
789 | 75 | 3 | 25 | 1 | 75 | 3 | =SUM(B4,D4,F4) | =SUM(C4,E4,G4) |
<tbody>
</tbody>
My question is this: I need the "Store" & "Case" columns to be every other and I need the sum of each. However, I also need to be able to delete an entire column. So, of course when I delete columns I get a reference error. I tried using Indirect =SUM(INDIRECT("B2"),INDIRECT("D2"),INDIRECT("F2")) so I could delete them but then it moves the total columns into the columns that are being added and causes issues. Is there a way to do this?
Hopefully I am explaining this well enough.
Thank you very much!
Mandy