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 encoun...
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