Hi Pinto
Try something like this:
C13=SUMPRODUCT(--(EmpName = B13), indirect($C$1))

Regards,
Pedro J.

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.