[Solved] Possible for row, but not for columns
[Solved] Possible for row, but not for columns
Why =SUM( 2 * G6:G20) is working, but =SUM( 2 * G6:Q6) is not working?!!!
Last edited by gudij on Wed Jun 20, 2018 6:46 am, edited 1 time in total.
OpenOffice 4.1.3 on Windows 7
Re: Possible for raw, but not for columns
Neither one works for me. =SUM( 2 * G6:G20) gives the wrong answer and =SUM( 2 * G6:Q6) gives a #VALUE error. I think you want to use
Code: Select all
= 2 * SUM(G6:G20)
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.
Re: Possible for raw, but not for columns
No, I want to multiply every cells into two rows (G6:Q6 and G3:Q3) and sum it later.
=SUMA( G6:Q6 * G3:Q3)
It giving to me an Error.
How can I do this?
Ps (it seems I make a mistake in title calling a column as a row.)
=SUMA( G6:Q6 * G3:Q3)
It giving to me an Error.
How can I do this?
Ps (it seems I make a mistake in title calling a column as a row.)
OpenOffice 4.1.3 on Windows 7
Re: Possible for row, but not for columns
If I understand you correctly, you want
That will return
Code: Select all
=SUMPRODUCT(G6:Q6;G3:Q3)
Code: Select all
G6 * G3 + H6 * H3 + ... +Q6 * Q3
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.