silentcoates
New Member
- Joined
- Oct 11, 2005
- Messages
- 41
Hello,
I have quite a few probs that I need to resolve I will try to list them all. I just want to thank you all for your help as this website has been invaluable to me.
anyway back to business.
I have a table and in one of the columns I have some percentage scores (this column has a formula in each cell =VLOOKUP(B4,'Input Sheet'!H2:L130,5,0) )some of the cells show DIV/0! (an error value or something like it) How do I get the cells to show a 0 value so whe I add a total cell at the bottom of the column it works as at the moment it shows DIV/0!
Also I have a list of names in alphabetical order next to which I have a list of scores (a percentage) on sheet two I have a list of 5 names from that original list. I need a formula to show the average score for the 5 names.
hope these all make sense
thanks
I have quite a few probs that I need to resolve I will try to list them all. I just want to thank you all for your help as this website has been invaluable to me.
anyway back to business.
I have a table and in one of the columns I have some percentage scores (this column has a formula in each cell =VLOOKUP(B4,'Input Sheet'!H2:L130,5,0) )some of the cells show DIV/0! (an error value or something like it) How do I get the cells to show a 0 value so whe I add a total cell at the bottom of the column it works as at the moment it shows DIV/0!
Also I have a list of names in alphabetical order next to which I have a list of scores (a percentage) on sheet two I have a list of 5 names from that original list. I need a formula to show the average score for the 5 names.
hope these all make sense
thanks