sumproduct function calculating wrong?

[donalde]

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)

 

[Nobby]

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

Your answer of 16950.07 is the sum of:
A1+B1+A2+B2+A3+B3+A4+B4+A5+B5

Nobby

 

[Aladin Akyurek]

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))

 

[Mark W.]

Use...

=SUMPRODUCT(A1:A5,B1:B5)

 

[donalde]

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

 

[Aladin Akyurek]

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.