It's almost always better to post an unrelated question as a separate
thread.

From Help:
Syntax
SUMPRODUCT(array1,array2,array3, ...)
Array1, array2, array3, ... are 2 to 30 arrays
whose components you want to multiply and then add.

So you can have up to 30 arrays. Note that Help is wrong - a single
array can be entered as well.

Add arrays the same way your existing arrays are added. Just make sure
the arrays are the same size.


In article ,
Tan wrote:

By the way, can you help with
my second questions as well.