subtracting from total multiple sheets (inventory) help.

[nks1510]

Hi there,
Need to input a formula for an inventory spreadsheet where in i can
deduct the supplies leaving a location from the total inventory.

There are aproximately 50 worksheets that are deducted from the total
inventory,
i.e
sheet 1 =total inventory (part 001)
sheets 2-50 load sheets (part 001 on each)

How can i deduct the total parts from 2-50 worksheets (part 001) to
reflect on total inventory (part 001 on sheet 1).

Is there a common formula for this?
Kinda new at this ...any help would be greatly appreciated.

Thanks

 

[Ron Rosenfeld]

Hi there,
Need to input a formula for an inventory spreadsheet where in i can
deduct the supplies leaving a location from the total inventory.

There are aproximately 50 worksheets that are deducted from the total
inventory,
i.e
sheet 1 =total inventory (part 001)
sheets 2-50 load sheets (part 001 on each)

How can i deduct the total parts from 2-50 worksheets (part 001) to
reflect on total inventory (part 001 on sheet 1).

Is there a common formula for this?
Kinda new at this ...any help would be greatly appreciated.

Thanks

If on each sheet, the total for part 001 is listed in cell C1, then the 3D
formula:

=SUM(Sheet50:Sheet2!C1)

will give you a grand total.


--ron