One way:

=sum(if(isnumber(a1:a10),a1:a10))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column--oddly enough, you
can use the whole row.

or maybe...

=SUMIF(A1:A10,"<#N/A",A1:A10)



G wrote:

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

--

Dave Peterson