I'd like to use a named range of "FactorA" (which contains multiple cells),
etc, and I'm trying to do something like this

=AVERAGE(IF(INDIRECT("Factor" &$B17)=$D17,IF($F$2:$F$9=E$16,$R$2:$R$9)))

Where B17 contains the A. Can I do this?

Thanks,
Barb Reinhardt