| 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/ |
| 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) | |||
Threaded Mode
