Thx Gary it worked like a charm!!

Regards
Thapelo


Gary''s Student wrote:
Say we have a table in Sheet1 from A1 thru D10. In Sheet2 we want the sum of
the first column in Sheet1. Use:

=SUM(Sheet1!A1:A10)

I have created formulas is sheet 1. I want to create a table in sheet 2 using
totals from sheet 1. How do I work with formulas between sheets?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200709/1