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