Hi Kevin,

Very useful. Follow-on question: in the formula

C13=SUMPRODUCT(--(EmpName = B13), (Amt))

is it possible to replace "(Amt)" with a reference to a cell which contains
the range name I'd like to use? For example, something like:

C13=SUMPRODUCT(--(EmpName = B13), ($C$1)), where C1 contains "AMT"

In other columns, like D, D1 would hold a range name for something else, etc.

Thanks.


"Kevin Vaughn" wrote:

You're welcome. Thanks for the feedback.
--
Kevin Vaughn