Results 1 to 5 of 5

Thread: Formula Gurus needed

  1. #1

    Formula Gurus needed



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi

    I need a formula to calculate total hours by adding G114 to G149 depending on whether the corresponding number in column H is either 1,2, or 3. (column H has a drop down list with these options)

    Thanks!

  2. #2
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Location
    Askew
    Posts
    183
    Articles
    0
    Excel Version
    2010
    Your question isn't particularly clear, to me at least - do you mean:
    =IF(OR(H1={1,2,3}),G114+G149,0)
    Perhaps a sample workbook could be provided?
    Circumference of a circle = 2πr²



    ²the circle's radius

  3. #3
    How about this?

    =SUMIF(I114:I149,">0", J114:J149) - SUMIF(I114:I149,">4", J114:J149)

  4. #4
    Start Time End Time Hours Rate
    10:30 AM 3:30 PM 5 1
    5:00 PM 10:00 PM 5 1
    12:00 PM 8:00 PM 8 1
    9:30 AM 1:00 PM 3.5 1
    1:00 PM 5:00 PM 4 1
    7:00 PM 9:00 PM 2 1
    10:15 AM 2:00 PM 3.75 2
    2:30 PM 4:30 PM 2 1
    5:00 PM 10:00 PM 5 2
    12:00 PM 2:30 PM 2.5 1


    Hours column is G, Rate Column is H. I need to add the hours in G for all rate 1, then a different cell to add all rate 2s and so on

  5. #5
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Location
    Askew
    Posts
    183
    Articles
    0
    Excel Version
    2010
    =SUMIF(H114:H149,1, G114:G149)
    then
    =SUMIF(H114:H149,2, G114:G149)
    and so forth

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •