Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a cell with text on it as part of a SUM formula
Using an indirect command, I got "Bond!D1:D5" in cell A1. "Bond" is the
name of one of my tabs. I want to sum the values in the Bond tab, cells D1:D5, using the text displayed in cell A1. In other words, I want to use SUM(Bond!D1:D5) in cell A2, but I don't want to type the "Bond!D1:D5" portion, but rather pull it from cell A1, which is showing "Bond!D1:D5"...obviously, =sum("A1") didn't work. I'm attaching the example in case I have managed to confuse everybody. Thanks a lot for your help! Attachment filename: test.xls Download attachment: http://www.excelforum.com/attachment.php?postid=431003 --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a cell with text on it as part of a SUM formula
Hi mmorganb,
That is what you should use the INDIRECT worksheet function for. Enter this in A2: =SUM(INDIRECT(A1)) -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Using an indirect command, I got "Bond!D1:D5" in cell A1. "Bond" is the name of one of my tabs. I want to sum the values in the Bond tab, cells D1:D5, using the text displayed in cell A1. In other words, I want to use SUM(Bond!D1:D5) in cell A2, but I don't want to type the "Bond!D1:D5" portion, but rather pull it from cell A1, which is showing "Bond!D1:D5"...obviously, =sum("A1") didn't work. I'm attaching the example in case I have managed to confuse everybody. Thanks a lot for your help! Attachment filename: test.xls Download attachment: http://www.excelforum.com/attachment.php?postid=431003 --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a cell with text on it as part of a SUM formula
Hi
try =SUM(INDIRECT(A1)) if A1 stores your cell reference as string Frank Using an indirect command, I got "Bond!D1:D5" in cell A1. "Bond" is the name of one of my tabs. I want to sum the values in the Bond tab, cells D1:D5, using the text displayed in cell A1. In other words, I want to use SUM(Bond!D1:D5) in cell A2, but I don't want to type the "Bond!D1:D5" portion, but rather pull it from cell A1, which is showing "Bond!D1:D5"...obviously, =sum("A1") didn't work. I'm attaching the example in case I have managed to confuse everybody. Thanks a lot for your help! Attachment filename: test.xls Download attachment: http://www.excelforum.com/attachment.php?postid=431003 --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a cell with text on it as part of a SUM formula
=SUM(INDIRECT(A1))
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "mmorganb " wrote in message ... Using an indirect command, I got "Bond!D1:D5" in cell A1. "Bond" is the name of one of my tabs. I want to sum the values in the Bond tab, cells D1:D5, using the text displayed in cell A1. In other words, I want to use SUM(Bond!D1:D5) in cell A2, but I don't want to type the "Bond!D1:D5" portion, but rather pull it from cell A1, which is showing "Bond!D1:D5"...obviously, =sum("A1") didn't work. I'm attaching the example in case I have managed to confuse everybody. Thanks a lot for your help! Attachment filename: test.xls Download attachment: http://www.excelforum.com/attachment.php?postid=431003 --- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a cell with text on it as part of a SUM formula
Guys,
Thanks for your prompt reply (in fact, I found out I was making an obvious mistake). Your help was greatly appreciated. Michael --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF cell contains part of text | Excel Worksheet Functions | |||
Get part of text in a Cell | Excel Discussion (Misc queries) | |||
find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
USE PART OF TEXT FROM ONE CELL IN ANOTHER | Excel Discussion (Misc queries) | |||
How do I format text that is part of a formula? | Excel Discussion (Misc queries) |