Hi my Heroes!

I have put an excel sheet in the attach showing what's bugging me. When I change the number of working days in sheet1, there should be a change in sum per item from sheet2. The example should give a bit more clarity... Thanks! Srecak:rolleyes:

See the attached. In Sheet1 you will enter =Sum(Sheet2!C3:e3) for example for product K, 3 day total. Just copy that formula down the column to fill in the rest of the cells. Then do the same for the 8 day total but the range is c3:j3.

Quote:

---

Originally Posted by mdosh01

See the attached. In Sheet1 you will enter =Sum(Sheet2!C3:e3) for example for product K, 3 day total. Just copy that formula down the column to fill in the rest of the cells. Then do the same for the 8 day total but the range is c3:j3.

---

Not what I'm looking for, sorry. When I change the 'number of working' days in sheet1, the calculation should be automatic (example of result is the second column for 8 working days)...

OK. The attached method requires a second table with the days total accumulated in Sheet 2. Then HLOOKUP is used to find the specified day's total.

I looked at your attachment. What I don't understand is why you expect numbers to change when you have no formulas. All your entries are just types in.

The way a spreadsheet works to change results when you change parameters is by entering formulas using cell references. For example; you might have a situation where you enter a unit price in cell C2 and a quantity in D2 and you want E2 to show the extended price. In that case you enter:
=C2*D2
in cell E2. You can then copy that formula down the E column so it will do the same calc for each row.

I think the use of an HLookup is probably what you want. But I think you need to have a better understanding of how spreadsheets work.