Thanks:  0
Likes:  0

# Thread: sumproduct function calculating wrong?

1. I create new sheet, format all cell to be number type. Then I paste data from another sheet, using paste special -> values
A B
15973,26 1,00
318,10 18,00
98,94 8,00
251,09 1,00
276,68 4,00
column A has value, column B has multiplier for value. When I count A1*B1+A4*B4+A5*A6 I get 17331,07 which is correct. But when I use =SUMPRODUCT(A1:B5) I get value 16950,7 which is impossible value. Correct value would be 23848,30. Does somebody have clue where this goes wrong? Same error happens when using general type cells. Desimal
separator is , (european style)

2. Based on the data you posted, the sums you are getting are correct.

A1+B1+A2+B2+A3+B3+A4+B4+A5+B5

Nobby

3. On 2002-03-06 05:18, donalde wrote:
I create new sheet, format all cell to be number type. Then I paste data from another sheet, using paste special -> values
A B
15973,26 1,00
318,10 18,00
98,94 8,00
251,09 1,00
276,68 4,00
column A has value, column B has multiplier for value. When I count A1*B1+A4*B4+A5*A6 I get 17331,07 which is correct. But when I use =SUMPRODUCT(A1:B5) I get value 16950,7 which is impossible value. Correct value would be 23848,30. Does somebody have clue where this goes wrong? Same error happens when using general type cells. Desimal
separator is , (european style)
It's:

=SUMPRODUCT((A1:A5)*(B1:B5))

4. Use...

=SUMPRODUCT(A1:A5,B1:B5)

5. Many thank to all who replied, I have made stupid mistake on syntax. Mark W, thanks for giving correct syntax.

6. On 2002-03-06 22:53, donalde wrote:
Many thank to all who replied, I have made stupid mistake on syntax. Mark W, thanks for giving correct syntax.
=SUMPRODUCT((A1:A5)*(B1:B5))

is also correct syntaxwise.

## User Tag List

#### Posting Permissions

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