Having problems adding several columns up.

[georj]

i have several lookups like this one "=VLOOKUP($P2,weight,2,FALSE)" when it can not find something it puts #N/A i have two other lookups which do the same thing sort of thing but when i come to add the columns together it cant because of the #N/A now two columns may have numbers in them but the third might not is there a way round this please.

thank you for your time and help

Jason

 

[Andrew Poulsom]

You can either eliminate the error like this:

=IF(ISNA(VLOOKUP($P2,weight,2,FALSE)),0,VLOOKUP($P2,weight,2,FALSE))

or sum excluding the NA values like this:

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

 

[Peter_SSs]

Jason

One way is this:
=IF(ISNA(VLOOKUP($P2,weight,2,0)),"",VLOOKUP($P2,weight,2,0))

 

[georj]

Thank you both for all your help both ways worked.
have a good day and take care

Jason