View Single Post
  #1   Report Post  
Moy Emrick
 
Posts: n/a
Default getting the sum of a column with #N/A values in it

I created a VLookup formula to display the value of an item if it exists. If
the value doesn't exist, it displays an #N/A. 1) Can I modify this formula to
display a "0" instead of an #N/A? and 2) How can I total a column which only
excludes #N/A? A copy of my formula is below.

=VLOOKUP(B156,'2003'!B:T,3,0)

Thank you very much.
Moy Emrick