| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Cell Variables to Specify Cell Range
Hi There, I'm looking to make a worksheet as dynamic as possible. I want to define a range of ROWS (rows 15 - 30) in table cells (ex: A1= 15 , A2= 30) I then want to reference these definitions in a formula like the one below: =SUM(COUNTIF(DataWorkSheet!L$*15*:L$*30*,$A16)/$B$10) Unfortunately I don't know how to reference variables "15" and "30" to make the formula above dynamic. My dream is to input row numbers (range) into cells A1 and A2 and then reference the "VALUES" of these cells in the formula above. Basically, I don't want to hard code "15" and "30" into the formula above. Any suggestions? Thanks! -- jcottam ------------------------------------------------------------------------ jcottam's Profile: http://www.excelforum.com/member.php...o&userid=33049 View this thread: http://www.excelforum.com/showthread...hreadid=528653 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Reference with Range Name | Excel Worksheet Functions | |||
| need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) | |||
| How do I change a cell range with a reference cell? | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Reveal cell formats and extendable range in tool/statusbar/icon. | Excel Worksheet Functions | |||
Threaded Mode
