Forum Discussion

Apryl Allen's avatar
Apryl Allen
Copper Contributor
Jul 31, 2017

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...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 31, 2017

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.

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 31, 2017

    and perhaps

    =SUM(INDEX(Sheet2!48:48,,6):INDEX(Sheet2!48:48,,100))

    or like

Resources