View Full Version : Sum according to working days
Srecak
Jan 29, 2009, 02:02 PM
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:
mdosh01
Jan 30, 2009, 06:30 AM
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.
Srecak
Jan 30, 2009, 06:37 AM
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)...
mdosh01
Jan 30, 2009, 07:37 AM
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.
ScottGem
Jan 30, 2009, 07:49 AM
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.