I've got a number of fields with VLOOKUP formula that will NOT be populated
until a later date. However, I'm trying to sum up all fields at the same
time, even though they won't be populated.

As you would expect, I'm getting a "#NA" for fields that are not populated
and the SUM is also "#NA".

Is there a way to bypass all "#NA" fields when I SUM them and get the total
of all fields that ARE populated?

Thanks in advance for your help.

G