Adding the value of a user-inputted cell to a cell reference

Hi all,

I have a spreadsheet that takes the sum of scrap pieces and multiplies it by the value of the piece per day. A set consists of three columns (three shifts per day). On a separate sheet, I've done the same for different work centers that use the same parts. Traditionally I've added the value scrapped on the separate sheet to the total value on the original sheet to get my total scrap value--this works fine. However, my boss wants to actually see how many pieces total are being scrapped by part number by day, not just their values.

My question is, is it possible to have a cell that takes a user input and automatically adds the value from a cell reference; such that a cell contains only the cell reference until a user activates the cell and enters data, then subsequently the cell will contain said data + the value of the cell referenced?

i.e. =[whatever the user enters]+'sheet2'!A1
wherein the user simply selecting the cell and entering information won't negate the pre-existing "+'sheet2'!A1"

Thanks for any input!

You can't do that with a formula, although you could have a formula in an adjacent column to do it for you - enter data in D1, say, and in E1 you can have this formula:

=IF(D1="","",D1+Sheet2!A1)

so that it only shows once you have put something in D1.

Hope this helps.

Pete