Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    See attached worksheet. What I would like to do is on worksheet, sum the numbers from worksheet 1 where the dates and point names (i. e., AV, BP, WN, etc.) match. I know this has been addressed before, but I can't seem to put my finger on it!
    Thanks in advance.
    Jeff
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    In B2 on Sheet2:

    =SUMPRODUCT((Sheet1!$B$1:$B$30=$A2)*(Sheet1!$A$1:$ A$30=B$1),Sheet1!$C$1:$C$30)

    Fill down, then right (or right, then down)

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='775597' date='17-May-2009 14:16']In B2 on Sheet2:

    =SUMPRODUCT((Sheet1!$B$1:$B$30=$A2)*(Sheet1!$A$1:$ A$30=B$1),Sheet1!$C$1:$C$30)

    Fill down, then right (or right, then down)[/quote]

    Hans,
    Tried that, and I got a "VALUE message.
    Any other ideas?
    Thanks,
    Jeff

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Try again and make sure that you enter the formula correctly. It does work!

    (It doesn't need to be an array formula, by the way. The 'array' aspect is implicit in the SUMPRODUCT function.)

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    [quote name='jlkirk' post='775606' date='17-May-2009 15:02']Hans,
    Tried that, and I got a "VALUE message.
    Any other ideas?
    Thanks,
    Jeff[/quote]

    Never mind...I found my error. Thanks.

Posting Permissions

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