Ask Experts Questions for FREE Help !
Ask
    Srecak's Avatar
    Srecak Posts: 11, Reputation: 1
    New Member
     
    #1

    Jan 29, 2009, 02:02 PM
    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:
    Attached Files
  1. File Type: xls SumPerWDays.xls (20.0 KB, 105 views)
  2. mdosh01's Avatar
    mdosh01 Posts: 64, Reputation: 8
    Junior Member
     
    #2

    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.
    Attached Files
  3. File Type: xls Copy of SumPerWDays.xls (26.5 KB, 119 views)
  4. Srecak's Avatar
    Srecak Posts: 11, Reputation: 1
    New Member
     
    #3

    Jan 30, 2009, 06:37 AM
    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)...
    mdosh01's Avatar
    mdosh01 Posts: 64, Reputation: 8
    Junior Member
     
    #4

    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.
    Attached Files
  5. File Type: xls Copy of SumPerWDays.xls (28.5 KB, 109 views)
  6. ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #5

    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.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

I started my period 2 days after unprotected sex, It only lasted 2 1/2 days. [ 6 Answers ]

I know I've already asked if I could be pregnant because I started my period only 2 days after having sex. I've gotten feed back and that reassured me, but the weird thing is my period only lasted 2 days. I started on Tuesday morning and by late thursdy night I was already finished, which isn't...

A/C works fine for days, then stops working for about 8 hours. [ 2 Answers ]

A/C in the past few weeks turns on and off; last night the A/C was not working and the thermostat was blank. Then, by itself, it suddenly kicked in and started blowing cold air and thermostat showed the temp. This occurs once in a while. Works fine for days, then suddenly stops working for about...

Pregnant and working 12 hour days [ 6 Answers ]

I am 5 months pregnant and I am a manager at a restaurant. At my job managers serve tables and it is a small location and very fast paced. I do not really get breaks, sometimes working the entire 12 hours with no time to sit down. I am required to do more work than the other women I work with,...

Six days later we are working things out. [ 1 Answers ]

We broke up last Wednesday and today, we met up to talk. He said he missed me and would like to take a step back. We broke up because we constantly argued. I was wondering if anyone has experience breaking up and getting back together. Does it really work? How do you take a step back? We were...

Need to give 60 days notice, but rent is increasing in thirty days [ 3 Answers ]

I have rented the condo I am in now for over two years. After the initial lease term of one year, I went on a month-to-month basis. I am required to give 60 days notice prior to vacating the property. My landlord notified me at the end of this month (february) that the rent would be...


View more questions Search