I suggest that you look at the help again, and see whether the SUM function
was actually being used to sum more than one value. If not, perhaps you
could let us know where in help you found this?
--
David Biddulph

CONFUSED AT WORK wrote:
The Edit, Links, worked great thank you. I wasnt sure on how to get
the info from another worksheet and went in the help file, the
example there had sum in front of it.

Thanks everyone.