probably a simple question but...

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

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)?
 
Matt wrote...
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)?
Click to expand...

Hi Matt,

That sounds like an opportunity to use pivot tables. You can learn more
about them here:

http://www.peltiertech.com/Excel/Pivots/pivotstart.htm

http://edferrero.m6.net/Pivot.html

http://www.cpearson.com/excel/pivots.htm

To answer your specific question, yes you can have data on sheets one and
two with a summary on sheet three.

Sheet 3 Cell A1:

=Sheet1!A1+Sheet2!A1

That adds the information from Sheets 1 and 2 on cell A1.

But have a look at pivot tables. They do take some time to learn.

Best regards,
Kevin
 
Back
Top