I was wondering if its possible to extend a formula to lower cells, while keeping certain figures fixed? I'll give an example to try make it clearer
say my original formula was in cell A1 and the formula was "A2+A3+A4".
Now i'd like to extend this formula to cell B1, so i do that and the formula reads "B2+B3+B4"
Instead of this, i want the formula in cell B1 to be "B2+B3+A4"
and then for cell C1 to be "C2+C3+A4" ect.
tryed to make that as clear as i could, hope you can help,
Thanks
try this in A1
Formula:
Please Login or Register to view this content.
extend across
Hope this helps
-Edit-
the $A keeps the last argument referencing the same column, so
B1 would look like =B2+B3+$A4, etc
Last edited by dredwolf; 11-22-2012 at 11:21 PM. Reason: forgot to close formula tags ...oops
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Hi Milky,
welcome to the forum.
try this is cell A1
dollar sign means absolute reference which will stop the cell reference from moving when you copy the formula down.
Please Login or Register to view this content.
Regards,
Hyperdude
Hi Milky,
As Hyperdude and dredwolf both rightly said, what you need is absolute referencing.
If you want to learn more about relative and absolute referencing, read about it in my article here.
Taming the Excel dragon... www.TheExcelphile.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks