#N/A - - Can someo help me get this fixed?

[scobad]

Formula: =VLOOKUP(E2:E9000,Taken10!$A2:$H$900,7,FALSE)

If it is #N/A

I would like it to return o (zero)

I am trying to sum ytd hours for a earning. and The N/A is messing me up

 

[scobad]

Here is what I am summing


SUMIF(K2-N2-O2-P2,"<>#N/A")

That does not work either?

After I get rid of the #N/A I need to "K2-N2-O2-P2"

 

[Aladin Akyurek]

Here is what I am summing


SUMIF(K2-N2-O2-P2,"<>#N/A")

That does not work either?

After I get rid of the #N/A I need to "K2-N2-O2-P2"

=IF(ISNUMBER(K2),K2,0)-SUMIF(N2:P2,"<>#N/A")