Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Sum according to working days (https://www.askmehelpdesk.com/showthread.php?t=310368)

  • Jan 29, 2009, 02:02 PM
    Srecak
    1 Attachment(s)
    Sum according to working days
    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:
  • Jan 30, 2009, 06:30 AM
    mdosh01
    1 Attachment(s)
    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.
  • Jan 30, 2009, 06:37 AM
    Srecak
    Quote:

    Originally Posted by mdosh01 View Post
    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)...
  • Jan 30, 2009, 07:37 AM
    mdosh01
    1 Attachment(s)

    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.
  • Jan 30, 2009, 07:49 AM
    ScottGem

    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.

  • All times are GMT -7. The time now is 01:24 AM.