Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula help
I have a formula I want to copy down columns, but I want to keep half o it to remain the same, is there some way to lock some of it? This is the formula: '=SUM(E4*Sheet2!A2)' the next row needs to be =SUM(E5*Sheet2!A2), then =SUM(E6*Sheet2!A2). As it shows the -Sheet2!A2- needs to remain the same. I use the drag method to copy the formula, but it increases both part resulting in: =SUM(E4*Sheet2!A2), then =SUM(E5*Sheet2!A3), then =SUM(E6*Sheet2!A4). Can anyone help me, as going down what will become more than 100 row changing the second half back to A2 is extremely tedious and annoying -- densityflu ----------------------------------------------------------------------- densityflux's Profile: http://www.excelforum.com/member.php...fo&userid=2357 View this thread: http://www.excelforum.com/showthread.php?threadid=38764 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula help
Solved it, the special use of a '$' sign :) =SUM(E2*(Sheet2!$A$2)) - this is how to do it, just in case... -- densityflux ------------------------------------------------------------------------ densityflux's Profile: http://www.excelforum.com/member.php...o&userid=23574 View this thread: http://www.excelforum.com/showthread...hreadid=387642 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula help
You could even drop the =sum() part:
=e2*sheet2!$a$2 should work just fine. densityflux wrote: Solved it, the special use of a '$' sign :) =SUM(E2*(Sheet2!$A$2)) - this is how to do it, just in case... -- densityflux ------------------------------------------------------------------------ densityflux's Profile: http://www.excelforum.com/member.php...o&userid=23574 View this thread: http://www.excelforum.com/showthread...hreadid=387642 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |