Excel formulas

[Closed]
Report
Posts
5
Registration date
Saturday May 3, 2008
Status
Member
Last seen
May 17, 2009
-
Posts
5
Registration date
Tuesday March 11, 2008
Status
Member
Last seen
May 29, 2009
-
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.

1 reply

Posts
5
Registration date
Tuesday March 11, 2008
Status
Member
Last seen
May 29, 2009

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.