#N/A in SUM

[RussChilds]

Hi All,

I have a cell (V4) that works out the total point score of cells C4 to U4 "=SUM(C4:U4)"

The Cells C4 to U4 are using a lookup formula "=VLOOKUP(Units!P44,GRADE,2,FALSE)*10"

My question is if some cells give a #N/A it won't give a total points score. Instead I get a #N/A. How do I ignore the #N/A in cells C4 to U4?

Many thanks,
Russ

 

[RussChilds]

Sorry ignore.

=SUMIF(C4:U4,"<>#N/A")

 

[RoryA]

You could fix the VLOOKUPs to return something other than an error, or you can use SUMIF:

=SUMIF(C4:U4,"<>#N/A")

 

[RussChilds]

Thanks RoryA!