Previous Topic Next Topic

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.

1 reply

Answer 1 / 1
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