| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Named Range within an Array Formula
I am trying to refer to a named range within an array formula without a great
deal of success - my original formula is as follows: {=SUM(IF(Data!$A$2:$A$145=$B$6,IF(Data!$B$2:$B$145 =$B7,Data!$C$2:$C$145,0),0))} I want to change the reference "Data!$$B$2:$B$145" to the dynamicly named range "Capital_Classification_1" so that if any extra lines of data are added to the Data worksheet the array formula automatically picks this new data up without me having to re-set the range in the array. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count(if(... using array formula: can I use a named range in my ca | Excel Worksheet Functions | |||
| Use named ranges in array formula | Excel Worksheet Functions | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| Named range into an array | Excel Worksheet Functions | |||
| Array to named range conversion... | Excel Discussion (Misc queries) | |||
Threaded Mode
