D
Darby
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.
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.