Forum Discussion
Excel Formula - Is what I need an absolute formula? If so, the "$" is not working
I have various tabs (pages) in a workbook. On the 1st tab (aka cover sheet) I need a formula in one cell that will allow me to take the total sum from a row of cells on tab #2. The problem I'm encountering is each month I need to insert a new column at the beginning of the row. I want the total to include the inserted column. I've tried using the absolute sign ($) $F$48, however, when I insert the column it changes the formual to $G$48. How do I tell Excel to always start with the "F" column on tab #2?
2 Replies
Hi Apryl,
First what in mind is to use INDIRECT, directly with string or in combination with ADDRESS. Or OFFSET on A column if you don't insert very first column in the sheet.
and perhaps
=SUM(INDEX(Sheet2!48:48,,6):INDEX(Sheet2!48:48,,100))
or like
