Excel formulas

Closed
mohaganee Posts 5 Registration date Saturday May 3, 2008 Status Member Last seen May 17, 2009 - Jul 5, 2008 at 08:19 AM
noblepentium Posts 5 Registration date Tuesday March 11, 2008 Status Member Last seen May 29, 2009 - Jul 5, 2008 at 10:48 AM
Hello,


I just create a database on excel , it is a daily record for my internal production , I would like to link some sheets together and get a recap of total sum in another sheet

what is the correct formulae to be use for linking sheets?

and also i would like to make a graph that shows the evolution of the production all thoughout the month


how can i do that i am not an expert in those things but is seems more practical that using a paper and calculate manually.
Related:

1 response

noblepentium Posts 5 Registration date Tuesday March 11, 2008 Status Member Last seen May 29, 2009
Jul 5, 2008 at 10:48 AM
Linking sheets is a very simple process what you have to do is to is to use below formulae


=Sheet2!A1+Sheet2!A1

Sheet 2 : will be the sheet where the result will appear
!A1 will be the cell + ( as per your need)
you can rename your sheet also


go to Insert and select graph wizard.. and select as per you request.
0