Something like =Sum(Sheet1!A2:A65536) will sum all the values in column A,
assuming you're using Row 1 as the headings.
************
Anne Troy
www.OfficeArticles.com

"roy.okinawa" wrote in message
...
I have one worksheet that is the master file/worksheet. I want to
create/use
another worksheet that sums/counts data from the master file/worksheet.
How
do I input formulas on the second worksheet to sum/count data from the
first?