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.
Related:

1 response

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.

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses