So im not sure how i can shorten then formula and im not really that familiar with excel. I have a list of categories each one is assigned a number, i need to take a value from a different cell and add them all up and divide by another cell. Heres the formula i have now.

=IF(ISNA(VLOOKUP(65,hey_1,5,0)=TRUE),0,VLOOKUP(65,hey_1,5,0))/
(IF(ISNA(VLOOKUP(16,hey_1,5,0)=TRUE),0,VLOOKUP(16,hey_1,5,0))+
IF(ISNA(VLOOKUP(17,hey_1,5,0)=TRUE),0,VLOOKUP(17,hey_1,5,0))+
IF(ISNA(VLOOKUP(18,hey_1,5,0)=TRUE),0,VLOOKUP(18,hey_1,5,0))+
IF(ISNA(VLOOKUP(19,hey_1,5,0)=TRUE),0,VLOOKUP(19,hey_1,5,0))+
IF(ISNA(VLOOKUP(20,hey_1,5,0)=TRUE),0,VLOOKUP(20,hey_1,5,0))+
IF(ISNA(VLOOKUP(21,hey_1,5,0)=TRUE),0,VLOOKUP(21,hey_1,5,0))+
IF(ISNA(VLOOKUP(22,hey_1,5,0)=TRUE),0,VLOOKUP(22,hey_1,5,0))+
IF(ISNA(VLOOKUP(24,hey_1,5,0)=TRUE),0,VLOOKUP(24,hey_1,5,0))+
IF(ISNA(VLOOKUP(26,hey_1,5,0)=TRUE),0,VLOOKUP(26,hey_1,5,0))+
IF(ISNA(VLOOKUP(27,hey_1,5,0)=TRUE),0,VLOOKUP(27,hey_1,5,0))+
IF(ISNA(VLOOKUP(30,hey_1,5,0)=TRUE),0,VLOOKUP(30,hey_1,5,0))+
IF(ISNA(VLOOKUP(31,hey_1,5,0)=TRUE),0,VLOOKUP(31,hey_1,5,0))+
IF(ISNA(VLOOKUP(32,hey_1,5,0)=TRUE),0,VLOOKUP(32,hey_1,5,0))+
IF(ISNA(VLOOKUP(33,hey_1,5,0)=TRUE),0,VLOOKUP(33,hey_1,5,0))+
IF(ISNA(VLOOKUP(35,hey_1,5,0)=TRUE),0,VLOOKUP(35,hey_1,5,0))+
IF(ISNA(VLOOKUP(79,hey_1,5,0)=TRUE),0,VLOOKUP(79,hey_1,5,0)))
This would work if i could add the 0 to the end of the vlookup function to force it to find exact matches but it makes the formula too long. Thanks for any help.