# Thread: Another Sumif/Sumproduct Problem

1. 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!
Jeff

2. 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. [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. 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. [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
•