Does anyone know why? Or how to make that happen w/o retyping all 200
numbers (employee numbers) multiple times on the list? I know that
when I retype the numbers then the formulas can 'see' the number and do
the calcualtion, but not if I don't retype. The formats are the
same(number).

A C Z AA
1 EmpNo Units Empno Ttl Units
2 77 7 77 10 =SUMPRODUCT(Empno=Z2)*(units))
3 77 1 9533 11
4 77 2 10058 14
5 9533 7
6 9533 1
7 9533 3
8 10058 6
9 10058 2
10 10058 3
11 10058 3

Any and all help would be greatly appreciated

Thanks
Chrism