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

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

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