hi

=SUMIF(B2:B15,"<#N/A")

Mike

On Thu, 22 Jan 2009 13:01:01 -0800, Lois
wrote:

I am trying to get a running sum from a list of VLookups where some of the
values have yet to be entered. Therefor some of the cells show as #N/A and
the sum formula SUM(B2:B15) is not working. How can I fix this. (just in case
not clear b2 is 5:47, B3 is 5:52 B4:b15 are currently #N/A but will change on
later dates)