SUMPRODUCT to long

i tried that, but the common function is inherent to the SUMPRODUCT.

i was thinking DSUM yet that too is proving difficult with multiple criteria.

i may have to detail unique identifiers in the data table such that there is only one SUMPRODUCT.

agguugggh....

That should have been put the
MATCH($F33,Tax_CalcData_Elem,0)
part into a separate cell......

If that doesn't make things small enough, put up an example file with some representative data, your drop downs, named ranges etc. Small enough to work with, but the same structure as your real file so you can easily transfer any solution.


rylo