| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
