Hi!

1.

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

2.

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

Biff

"Moy Emrick" <Moy wrote in message
...
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