Constant and Relative Questions
=SUM(B2+'Savings Tracker'!A4)
There is my formula....I am adding up values month by month....I need the "A" to stay constant, but the "4" to be relative.
So when I drag it to the next cell, I need it to read: =SUM(B2+'Savings Tracker'!A5)...
When I place a "$" sign in front of the A or in between, the formula will not come out right. It makes the entire A4 constant.
What am I doing wrong?
thanks in advance.
=$B$2+'Savings Tracker'!$A4
An absolute cell reference in a formula, such as $B$2, always refers to a cell in a specific location
Last edited by protonLeah; 11-29-2018 at 04:06 PM.
Ben Van Johnson
1st, you really dont need to use SUM when adding 2 cells together - it's not wrong, just unnecessary
=SUM(B2+'Savings Tracker'!A4)
=B2+'Savings Tracker'!A4
$ is used to absolute a cell reference, locking it so that when copied, it doesnt change.. it comes in 3 different "flavors"...
$A$1 absolutes the entire cell reference, it will not chance when copied down or across
$A1 absolutes only the column, "A" will not change when copied across, but "1" WILL change when copied down
A$1 absolutes only the row, "1" will not change when copied down, but "A" will change when copied across
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I suggest you have a read through this tutorial: https://edu.gcfglobal.org/en/excel20...-references/1/
Would you please update your forum profile to show which version of OFFICE you are using? Windows 7 is an operating system.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks