Thanks: 0
Likes: 0
Needs Pictures: 0
Picture(s) thanks: 0
Results 1 to 6 of 6
Thread: Excel formula
-
3rd January 2008, 10:17 AM #1
Excel formula
I run an Excel spreadsheet for tracking my banking over the year. I run one month to the page and total the Deposits and Withdrawals down to line 30 on each page. Columns C and D.
I want to bring forward these figures to a separate page that will show the total Deposits and Withdrawals for the year.
I tried the formula =SUM(Janec!C30) but this did not work.
Can someone please tell me where I have it wrong.
Thanks
Macca
-
3rd January 2008 10:17 AM # ADSGoogle Adsense Advertisement
- Join Date
- Always
- Location
- Advertising world
- Posts
- Many
-
3rd January 2008, 10:41 AM #2Senior Member
- Join Date
- Aug 2004
- Location
- Brierfield
- Age
- 66
- Posts
- 170
you need to specify each C and D cell in the SUM().
ie SUM(page1Cnn,page2Cnn,page3Cnn,etc,etc)
this will SUM all the totals into a single total which you can then reference elsewhere.End of another day milling
-
3rd January 2008, 12:38 PM #3Member
- Join Date
- Jan 2008
- Location
- Sunshine Coast, Qld
- Posts
- 82
Sounds like you need to use 'Pastelink'? Once you have a cell that contains the Sum of a column of deposits or withdrawals and you would like that cell to appear elsewhere on another worksheet (page), highlight that cell and copy it (e.g. Ctrl + C). Then go to the page where you want your summary of deposits or withdrawals to appear. Highlight a destination cell and then right mouse click on it. Select 'Paste Special' and then 'Pastelink'. From then on, any time the copied cell changes in value, the destination cell will automatically be updated.
You will probably know about the 'Autosum' button that adds up a column or row of figures? It's the Greek looking 'E' symbol button on the toolbar.
Another way to acheive Autosum is to press 'Alt' + '=' + 'Enter'. It works out to be faster (in my opinion) by not having to find/aim/click on a little button with the mouse. Hope that helps. Cheers.
-
3rd January 2008, 01:31 PM #4
The easy way is to go to the cell you want the final figure to appear in click on =
Change to the first page click on the total figure you want to show on the total page eg c 30 then press + then the next page c30 and so on. this will give you the sum of the cells on each page you clicked on. Even if the cell has no number it will not matter.regards
David
"Tell him he's dreamin.""How's the serenity" (from "The Castle")
-
3rd January 2008, 02:26 PM #5
Thanks to you all.
It now works OK and the formula looks like this
=SUM(January!C30+February!C30+March!C30+April!C30+May!C30+June!C30+July!C30+August!C30+September!C30+October!C30+November!C30+December!C30)
Macca
-
7th January 2008, 01:08 PM #6SENIOR MEMBER
- Join Date
- Jun 2007
- Location
- Blue Mountains
- Posts
- 817
Quicker formula
If the tabs are called January, February.... December, and are contiguous (no other tabs between them), you can use this formula:
=SUM(January : December!B3)
(remove the spaces before and after the colon in the formula)
AllanLast edited by ajw; 7th January 2008 at 01:13 PM. Reason: added spaced before and after colon, to prevent icon being inserted
Similar Threads
-
Excel questions
By Toolin Around in forum COMPUTERSReplies: 18Last Post: 6th November 2007, 06:49 PM -
Excel question
By Daddles in forum COMPUTERSReplies: 26Last Post: 6th June 2007, 12:29 AM -
Excel Timber Take Off Programs
By toecutter in forum ANNOUNCEMENTSReplies: 5Last Post: 15th November 2006, 09:55 PM -
Any Excel nerds out there that can offer assistance
By Toolin Around in forum NOTHING AT ALL TO DO WITH WOODWORKReplies: 12Last Post: 7th August 2006, 10:19 PM -
Need help in Excel VBA programming
By Wongo in forum NOTHING AT ALL TO DO WITH WOODWORKReplies: 11Last Post: 19th July 2006, 07:31 PM