We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

creating a rule to add 2 cells together automatically [closed]

asked 2021-01-02 17:56:01 +0200

delboyuk2508 gravatar image

updated 2021-05-19 15:12:40 +0200

Alex Kemp gravatar image

I am running a spreadsheet and I want to get 2 cells to automatically add together to give a total. I have 2 columns side by side and I want the column on the right to give me the total of the 2 cells to its left. I hope I have made sense.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-05-19 15:13:24.805952

2 Answers

Sort by » oldest newest most voted

answered 2021-01-02 18:19:08 +0200

sbarlster gravatar image

updated 2021-01-02 18:20:04 +0200

If you want the added values in column C. Does this work...


You can then drag that value down all the rows so every row does a similar calculation.

edit flag offensive delete link more



image description

Opaque gravatar imageOpaque ( 2021-01-02 18:33:25 +0200 )edit

🙂 ooo lovely demo. Much better than my words.

sbarlster gravatar imagesbarlster ( 2021-01-02 18:49:19 +0200 )edit

answered 2021-01-03 12:12:04 +0200

delboyuk2508 gravatar image

updated 2021-01-03 12:20:05 +0200

Many thanks for that it works a treat, I have also worked out the formular for subtraction too, if it is a negative amount I would like the figure coloured red how do I make it change the colour if a negative amount please?



edit flag offensive delete link more

Question Tools

1 follower


Asked: 2021-01-02 17:56:01 +0200

Seen: 40 times

Last updated: Jan 03