| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ranges
I want to index a range to other cell. or to a number. eg. sum(a1:a10), but
indexed to other cell or number, like sum(a1:a1+9). what function can i use? a1+9, must be a10. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ranges
Hi, You can use the INDIRECT function: =SUM(A1:INDIRECT("A"&B1)) use B1 to enter a row number for your range. or =IF(B10,SUM(A1:INDIRECT("A"&B1)),"") HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=488500 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find all named ranges in VB.NET? | Excel Discussion (Misc queries) | |||
| Multiple Ranges for a Chart | Charts and Charting in Excel | |||
| Problem with graph ranges | Charts and Charting in Excel | |||
| compare unique identifiers in multiple ranges | Charts and Charting in Excel | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Linear Mode
