Hi,
Please simplify this function:
=SUM(A1*B1; A2*B2; A3*B3; A4*B4)
What I'm trying to do is:
=SUM(A1*B1 ;A2*B2; A3*B3; ...An*Bn)
I guess my problem is can't figure out the syntax to apply range to it.
[Solved] Sum of products function range syntax
[Solved] Sum of products function range syntax
Last edited by RoryOF on Wed Feb 21, 2018 5:48 pm, edited 2 times in total.
Reason: Added green tick [RoryOF, Moderator]
Reason: Added green tick [RoryOF, Moderator]
OpenOffice 4.15 on Windows 7
Re: Sum of products function range syntax
Use the SUMPRODUCT() function like this
Code: Select all
=SUMPRODUCT(A1:A10;B1:B10)
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.