[libreoffice-users] Re: SUMPRODUCT() (just some thoughts, no question)

Johnny Rosenberg wrote:
> I guess the lack of knowledge of the SUMPRODUCT() function forced me
> to learn quite a few other functions, workarounds and tricks…

For reference, here's one of these "tricks" that could be used.  Let's say
you want to do the following:
= A1 * B1 + A2 * B2 + A3 * B3

You could use SUMPRODUCT() as follows:
= SUMPRODUCT(A1:A3, B1:B3)

Another way to do it is to enter the array function:
{= SUM(A1:A3 * B1:B3)}

The curly braces should not be typed manually, they will appear when you hit
CTRL+SHIFT+ENTER (this is called an array function).

Generally, I would suggest using SUMPRODUCT().  However, the array function
is more flexibly; you can do various different calculations with it.  For
instance, enter the array function below (without curly braces, end by
pressing CTRL+SHIFT+ENTER rather than ENTER) ...
{= SUM(A1:A3 ^ B1:B3)}
... to get the same result as ...
= A1 ^ B1 + A2 ^ B2 + A3 ^ B3

There is no equivalent function, like SUMPOWER() or whatever (that I'm aware
of, anyway).

For more information about array functions:
http://help.libreoffice.org/Calc/Array_Functions

Regards
Jack

--
View this message in context: 
http://nabble.documentfoundation.org/SUMPRODUCT-just-some-thoughts-no-question-tp3015004p3015145.html
Sent from the Users mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted