From XL Help ("About array formulas and array constants"):


Separate values in separate columns with commas (,) and values in
separate rows with semicolons (;). For example, to represent the
values 10, 20, 30, and 40 in four columns, enter {10,20,30,40}; to
represent the same values in four rows, enter {10;20;30;40}. For
2-by-4 array constant (two rows by four columns), you would enter
{10,20,30,40;50,60,70,80}.

So your first formula multiplies each element of A1:E1 by each element
of the one-column array (then adds), while the second formula multiplies
each element of A1:E1 against only its corresponding element in the
one-row array, then adds.


In article ,
"Epinn" wrote:

A1:E1 3 5 6 3 2

=SUMPRODUCT((A1:E1)*{1;2;3;4;5}) returns 285
=SUMPRODUCT((A1:E1)*{1,2,3,4,5}) returns 53

I use evaluate formula and I know what the above formulae do.

I am familiar with commas but semicolons are new to me. Anyone knows of any
documentation on SUMPRODUCT and semicolon? Don't think I saw semicolon in
Bob's paper.

By the way, SUM+CSE will return the same results respectively.

Please feel free to comment.

Thanks.

Epinn