Copying number over from last sheet and adding to it
Closed
Ags
-
May 5, 2016 at 05:18 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - May 7, 2016 at 08:08 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - May 7, 2016 at 08:08 PM
Related:
- Copying number over from last sheet and adding to it
- Little alchemy cheat sheet - Guide
- Google sheet right to left - Guide
- How to screenshot excel sheet - Guide
- Windows network commands cheat sheet - Guide
- Mark sheet in excel - Guide
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
May 7, 2016 at 08:08 PM
May 7, 2016 at 08:08 PM
Hello Ags,
A simple formula in each sheet should do this for you, as per the following example:-
Assume you are referencing Cell A1 in each sheet.
- In the May sheet, in Cell A1, place the following formula:-
=April!A1 + May!C1
with C1 being the cell in the May sheet from which you want to add the value to A1.
So, if the April A1 value is 10 and the May C1 value is 10, then the result in May A1 will equal 20.
Change the cell references to suit yourself.
You should be able to take it from here.
I hope that this helps.
Cheerio,
vcoolio.
A simple formula in each sheet should do this for you, as per the following example:-
Assume you are referencing Cell A1 in each sheet.
- In the May sheet, in Cell A1, place the following formula:-
=April!A1 + May!C1
with C1 being the cell in the May sheet from which you want to add the value to A1.
So, if the April A1 value is 10 and the May C1 value is 10, then the result in May A1 will equal 20.
Change the cell references to suit yourself.
You should be able to take it from here.
I hope that this helps.
Cheerio,
vcoolio.
