Addition to Subtraction?

[HessInAMess]

I'm trying to create an inventory sheet, i have a sheet that shows how
much inventory we have now in stock and an individual sheet for each
tech that shows how much inventory they each have. My problem is i'm
trying to link the sheets so that when i add inventory to a tech it
subtracts it for our stock sheet. But it doesn't work. Is it possible
to do what i'm trying? Is there anyway to have one formula that makes
a number add to one cell and subtract from another? Please help....

 

[Myrna Larson]

First of all, you say "one formula". A formula resides in a cell, and it
returns its result to THAT cell -- it can't "add to one cell and subtract from
another". Sounds like your stock sheet may not be laid out optimally. What
entries are you making manually on that sheet? I would expect it to be new
deliveries (positive) less assignments to the various techs (negative and
including the tech name), with one line for each entry. On the Tech sheets, to
get their total inventory, you would use a SUMIF formula that sums all of the
entries on the stock sheet for that tech, then negates the value. This
approach would not give you details on the tech sheets for their assignments,
only a current total.

OTOH, if you want to make the entries for the tech assignments on their
sheets, and only list on the stock sheet the receipts from suppliers, then to
get the total on hand, on the stock sheet you would use a formula that adds
the receipts from suppliers and subtracts the assignments -- it would have to
sum the entries on each of the tech sheets.