I am pretty good with excell, but I am having trouble creating a few items.
I would like to know if it is possible to create a formula that is linked to
cells on multiple sheets within the same workbook. I understand you can do
several simile formulas from sheet to sheet or paste links, that is simple.
I've using a "SUMIF" formula that basically looks for a given number (for
example 01 02 00, a job cost code) and follows the line which includes this
number and returns a value from the cell I point it to. (hard to explain). I
am trying to make a summary sheet if you will, that will look at all of the
other sheets in the workbook and make a running total of for.. example the
values turned in from the 01 02 00 number. There may be multiple 01 02 00
numbers on each sheet, so the new formula will have to do a similar search
like the SUMIF. Also I would like to be able to add additional sheets to the
workbook, that will automatically be included in the formula without any
adjustments. This is hard to explain, but should ring a bell to someone. If
you use a "$" in front of the cells within a formula it will ALWAYS refer to
that cell. I would like to have one cell on the summary sheet refer to ex.
cell F10 on everysheet within the workbook, no matter how many sheets I add.
So you think I could put something like SUM($F$10"sheet #1",$F$10"sheet #2)
etc...., however I want to be able to insert new sheets at any time. Please
Help.
--
Alarson

Hi good,

I am not sure if its will help you a lot, but...

=sum(Sheet1:sheet40!f10).

create a helper sheet at the end of your spreasheets bar, and if you create
a sheet between the first and the last the formula will update.

hth
regards from Brazil
Marcelo

"goodolehuskers" escreveu:

I am pretty good with excell, but I am having trouble creating a few items.
I would like to know if it is possible to create a formula that is linked to
cells on multiple sheets within the same workbook. I understand you can do
several simile formulas from sheet to sheet or paste links, that is simple.
I've using a "SUMIF" formula that basically looks for a given number (for
example 01 02 00, a job cost code) and follows the line which includes this
number and returns a value from the cell I point it to. (hard to explain). I
am trying to make a summary sheet if you will, that will look at all of the
other sheets in the workbook and make a running total of for.. example the
values turned in from the 01 02 00 number. There may be multiple 01 02 00
numbers on each sheet, so the new formula will have to do a similar search
like the SUMIF. Also I would like to be able to add additional sheets to the
workbook, that will automatically be included in the formula without any
adjustments. This is hard to explain, but should ring a bell to someone. If
you use a "$" in front of the cells within a formula it will ALWAYS refer to
that cell. I would like to have one cell on the summary sheet refer to ex.
cell F10 on everysheet within the workbook, no matter how many sheets I add.
So you think I could put something like SUM($F$10"sheet #1",$F$10"sheet #2)
etc...., however I want to be able to insert new sheets at any time. Please
Help.
--
Alarson