Results 1 to 6 of 6
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: A Better Formula (XP (2002))

    Try

    =SUMPRODUCT(B3:B0,C3:C40)

    (I assume that you want to multiply pay rates and number of hours, not employee names and pay rates <img src=/S/grin.gif border=0 alt=grin width=15 height=15>)

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A Better Formula (XP (2002))

    How about the formula SUM(A3:A40*B3:B40) entered as an array (CTRL+SHIFT+ENTER)?

    Alan

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    A Better Formula (XP (2002))

    <P ID="edit" class=small>(Edited by Tricky on 28-Dec-03 19:58. Corrected my example...Thanks Hans.)</P>Help! I'm looking for a better way to get a desired result. What I have is a list of employee names in the A column (A3:A40). In the B column is their respective pay rates. In the C column is the number of hours worked in a given work week, D column is another week, E another, etc,

    At the bottom of each weekly column (C42) for example), I'm attempting to display the total wages paid for that week. Looking for something simple, overtime is not a factor. I'm suffering from a mental block but I know there's got to be a better formula than:

    =(B3*C3)+(B4*C4)+(B5*C5)+(B6*C6)............
    - Ricky

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: A Better Formula (XP (2002))

    Just to make sure: Alan's formula is an array formula (to be confirmed with Ctrl+Shift+Enter), but mine isn't, it is a "normal" formula. Both should work fine.

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A Better Formula (XP (2002))

    But Hans' formula will work faster.
    Legare Coleman

  6. #6
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: A Better Formula (XP (2002))

    Thanks Hans and Alan...I appreciate the quick responses. I knew there was a way to do this using an array formula but I'm still unfamiliar with their usefulness. I'm going to use the solution that allows for simpler copying from one column to the next.

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    Follow-Up Note: I found that the auto-fill feature works fine for both methods provided the cell references for the first array is set to absolute, as in <font color=blue>$B$3:$B$40 </font color=blue>

    Thanks again
    - Ricky

Posting Permissions

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