Couple ways:

1) do the SUM on each sheet (e.g. in Sheet1!L1: =SUM(E1:K1) then on
Sheet2, column C enter =Sheet1!L1

2) Make sure your sheet references are in the proper syntax: Sheet2!
(don't miss the exclamation point) so "=Sum(Sheet2E1,F1,G1,H1,K1)"
really needs to be: =Sum(Sheet2!E1,F1,G1,H1,K1). note: you can shorten
this to: =Sum(Sheet2!E1:K1)

Hope this helps.

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=380884