RussChilds
Active Member
- Joined
- Jun 8, 2007
- Messages
- 267
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
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
