[Solved] Possible for row, but not for columns

Discuss the spreadsheet application
Post Reply
gudij
Posts: 3
Joined: Wed Jun 20, 2018 3:42 am

[Solved] Possible for row, but not for columns

Post by gudij »

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
FJCC
Moderator
Posts: 9231
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Possible for raw, but not for columns

Post by FJCC »

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.
gudij
Posts: 3
Joined: Wed Jun 20, 2018 3:42 am

Re: Possible for raw, but not for columns

Post by gudij »

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.)
OpenOffice 4.1.3 on Windows 7
FJCC
Moderator
Posts: 9231
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Possible for row, but not for columns

Post by FJCC »

If I understand you correctly, you want

Code: Select all

=SUMPRODUCT(G6:Q6;G3:Q3)
That will return

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.
gudij
Posts: 3
Joined: Wed Jun 20, 2018 3:42 am

Re: [solved]Possible for row, but not for columns

Post by gudij »

Thank you, solved.
OpenOffice 4.1.3 on Windows 7
Post Reply