Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking cells, please help!
I have 35 worksheets and would like to be able to add up the dollar figure
that is on my B10 cell. I've created a summary worksheet and just can't seem to get my formula correct. I was using this: =Sum(worksheetname!B10, etc, etc, Can someone please help! I would surely appreciate it. I am working with a deadline. Thanks!!!!! P.S. Working w. excel 2007 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking cells, please help!
From the summary sheet type
=SUM( then using the mouse select the B10 on the first sheet, hold down shift key and select the last sheet tab and press enter. Excel will help you by enclosing with a parenthesis. it will look like =SUM(Sheet1:Sheet10!B10) where Sheet1 and Sheet10 will be replaced with your real names -- Regards, Peo Sjoblom "Veronica_s" wrote in message ... I have 35 worksheets and would like to be able to add up the dollar figure that is on my B10 cell. I've created a summary worksheet and just can't seem to get my formula correct. I was using this: =Sum(worksheetname!B10, etc, etc, Can someone please help! I would surely appreciate it. I am working with a deadline. Thanks!!!!! P.S. Working w. excel 2007 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking cells, please help!
=SUM(Sheet1:Sheet35!B10)
If your sheet names are not the default.................... Insert a dummy sheet before all sheets....name it First Insert a dummy sheet after all sheets....name it Last Formula is then =SUM(First:Last!B10) Any new sheets can be inserted between First and Last like the jam in a sandwich. Sheet names are then inconsequential. Gord Dibben MS Excel MVP On Wed, 22 Aug 2007 07:48:34 -0700, Veronica_s wrote: I have 35 worksheets and would like to be able to add up the dollar figure that is on my B10 cell. I've created a summary worksheet and just can't seem to get my formula correct. I was using this: =Sum(worksheetname!B10, etc, etc, Can someone please help! I would surely appreciate it. I am working with a deadline. Thanks!!!!! P.S. Working w. excel 2007 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking cells, please help!
Veronica,
Try something like =SUM('FirstSheet:LastSheet'!B10) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Veronica_s" wrote in message ... I have 35 worksheets and would like to be able to add up the dollar figure that is on my B10 cell. I've created a summary worksheet and just can't seem to get my formula correct. I was using this: =Sum(worksheetname!B10, etc, etc, Can someone please help! I would surely appreciate it. I am working with a deadline. Thanks!!!!! P.S. Working w. excel 2007 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking cells, please help!
Not sure why your method wouldn't work.
I'd name each B10 cell on each sheet for ease of reference; ie. Total_A, Total_B and so on. On your summary sheet: =Total_A+Total_B..... hth -- Traa Dy Liooar Jock "Veronica_s" wrote: I have 35 worksheets and would like to be able to add up the dollar figure that is on my B10 cell. I've created a summary worksheet and just can't seem to get my formula correct. I was using this: =Sum(worksheetname!B10, etc, etc, Can someone please help! I would surely appreciate it. I am working with a deadline. Thanks!!!!! P.S. Working w. excel 2007 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking cells, please help!
Hi Veronica,
I'm not sure if this will work in 2007 but if you can try this in your summary sheet =SUM(Sheet2:Sheet35!B10) Replace Sheet2 with your first worksheet name that you want to sum and Sheet35 with your last worksheet name... Gav. "Veronica_s" wrote: I have 35 worksheets and would like to be able to add up the dollar figure that is on my B10 cell. I've created a summary worksheet and just can't seem to get my formula correct. I was using this: =Sum(worksheetname!B10, etc, etc, Can someone please help! I would surely appreciate it. I am working with a deadline. Thanks!!!!! P.S. Working w. excel 2007 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking cells, please help!
THANK YOU SOOOO MUCH!!! All your guys' help worked!!!! Whoo hoo! Thanks a
million! "Veronica_s" wrote: I have 35 worksheets and would like to be able to add up the dollar figure that is on my B10 cell. I've created a summary worksheet and just can't seem to get my formula correct. I was using this: =Sum(worksheetname!B10, etc, etc, Can someone please help! I would surely appreciate it. I am working with a deadline. Thanks!!!!! P.S. Working w. excel 2007 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking cells into empty cells in another worksheet | Excel Discussion (Misc queries) | |||
Linking cells with a diffrent sheet with 2 cells | Excel Worksheet Functions | |||
Linking cells | Excel Discussion (Misc queries) | |||
Linking Cells in a row. | New Users to Excel | |||
Linking a horizontal set of cells to a vertical sets of cells | Charts and Charting in Excel |