| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Defined Range Names in formulas
I am using Excel 2007 and am trying to reference defined name ranges in a
sumproduct formula. When I use the names the formula returns #N/A but when I replace the names with their ranges, the formula works fine. The formula that works is: =SUMPRODUCT(('Billing'!C2:C1000=C2)*('Billing'!B2: B1000=C1)*'Billing'!AK2:AK1000) The range 'Billing'!AK2:AK1000 is defined as SF_Rev. When I substitue 'Billing'!AK2:AK1269 with SF_Rev the formula fails. That formula is: =SUMPRODUCT(('Billing'!C2:C1000=C2)*('Billing'!B2: B1000=C1)*(SF_Rev)) Any thought would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| updating formulas with range names | Excel Discussion (Misc queries) | |||
| Input formulas in a defined data range and convert results as valu | New Users to Excel | |||
| Restoring formulas after deleting range names | Excel Worksheet Functions | |||
| How do you set up range names, name formulas | Excel Worksheet Functions | |||
| Sumif referring to range names formulas not updating | Excel Worksheet Functions | |||
Threaded Mode
