Spiky,

That did the trick. Thanks!



"Spiky" wrote:

Actually, I just realized I did that formula wrong, anyway. You only
wanted the sum of the days. Take out the first argument, it should
just be this:
=SUMPRODUCT(LOOKUP(B2:AY2,Sheet2!A1:B100))

If you got an N/A error, it probably means the database was incorrect.
It returns N/A with a bad Lookup.

I assumed that 5, 1, 10, 999, 220 were all job names. Was that correct?