J
Jarrod Price
I am a beginner with Excel, and a little lost. When creating a formula, is
it possible to use the content of a cell, without creating labels, to refer
to the cell, or group of cells in which the content appears? For example,
in countless places in my spreadsheet, the text "Total" appears in a cell,
refering to a numeric value, 4 columns to the right in the same row. I
would like to create a formula that adds all the values, wherever they
appear 4 columns to the right of the cell containing the text "Total". To
take this one step further, I would like to create a second formula that
does the same thing, but adds these values across multiple spreadsheets. I
realize that I can manually select these cells using the SUM function, but
the values appear too frequently throughout my spreadsheets for this to
work.
it possible to use the content of a cell, without creating labels, to refer
to the cell, or group of cells in which the content appears? For example,
in countless places in my spreadsheet, the text "Total" appears in a cell,
refering to a numeric value, 4 columns to the right in the same row. I
would like to create a formula that adds all the values, wherever they
appear 4 columns to the right of the cell containing the text "Total". To
take this one step further, I would like to create a second formula that
does the same thing, but adds these values across multiple spreadsheets. I
realize that I can manually select these cells using the SUM function, but
the values appear too frequently throughout my spreadsheets for this to
work.