I have an Excel 2000 document that basically sums up individual category
sales and calculates percent of total sales for each of location of our
company. What I'm wondering is, can I put one of these on sheet one of a
document, another on sheet two of the same document, and then create one on
sheet 3 that adds from sheets 1 & 2 to give me a total for the entire
company? And if so, then what would the basic functions look like?

And does anyone have a good web reference for learning more complicated
features of Excel (I'm just a beginner)?