Ask Your Question
0

How to move formula from cell to cell

asked 2017-04-13 09:49:13 +0200

_dave gravatar image

updated 2017-04-13 11:10:33 +0200

karolus gravatar image

I have a formula in cell B8 "=((A2*B2)+(A3*B3)+(A4*B4)+(A5*B5)+(A6*B6))" that I would like to copy that formula to other cells (C8,D8,E8...) without changing the cell reference of A2 to A6. Is there a way to do this?

I am enclosing a copy of the spreadsheet.

C:\fakepath\Current Shares Value.ods

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2017-04-13 11:23:18 +0200

robleyd gravatar image

I think the attachment may be what you want using absolute references for the column A - shares.ods.

edit flag offensive delete link more

Comments

Thank you for the suggestion, it works fine now.

_dave gravatar image_dave ( 2017-04-13 17:56:48 +0200 )edit
0

answered 2017-04-13 11:08:20 +0200

JohnSUN gravatar image

updated 2017-04-13 11:09:10 +0200

Try

=SUMPRODUCT($A$2:$A$6;B2:B6)
edit flag offensive delete link more

Comments

Yes, it works. I just don't see how, does "=SUMPRODUCT" simply adds the value? Could you show me how it works? Thanks for making it shorter.

_dave gravatar image_dave ( 2017-04-13 18:01:41 +0200 )edit

SUMPRODUCT: Multiplies corresponding elements in the given arrays, and returns the sum of those products. (There - by link - is an example with a picture)

JohnSUN gravatar imageJohnSUN ( 2017-04-13 18:41:44 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-04-13 09:49:13 +0200

Seen: 142 times

Last updated: Apr 13 '17