Excel formulas

Closed
mohaganee Posts 5 Registration date Saturday 3 May 2008 Status Member Last seen 17 May 2009 - 5 Jul 2008 à 08:19
noblepentium Posts 5 Registration date Tuesday 11 March 2008 Status Member Last seen 29 May 2009 - 5 Jul 2008 à 10:48
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 11 March 2008 Status Member Last seen 29 May 2009
5 Jul 2008 à 10:48
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.