Re: [libreoffice-users] Re: SUMPRODUCT() (just some thoughts, no question)
2011/6/2 Jack :
>
> 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
>
In my case I needed a SUMIF()-like function that allowed more than one
condition for more than one column. It's possible to solve without the
SUMPRODUCT() function, but all the solutions I came up with are pretty
ugly…
Best regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
In case of problems unsubscribing, write to postmas...@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
[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+h...@libreoffice.org
In case of problems unsubscribing, write to postmas...@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
