M

#### Mike

I'm trying to come up with a way in Excel to QA customer service phone

calls. I've created a simple spreadsheet to add up the scores for sections

of the sheet and have added a formula to convert them to a percentage. For

instance, the first section has three questions worth 2 points each for a

possible total of 6. The formula to convert it to a percentage is

=SUM(C8:C10)/6 This formula works fine when adding values of 0 and 2, but

depending on the type of call, not all questions are applicable, so I'd like

to add a value of NA. However Excel sees NA as a 0, thus skewing the

percentages. I'd like to give NA a value of 2. Sure, I can just enter the

full value, but would prefer to see NA in the cell. Is there any way that I

can do this? Any help or suggestions would be most appreciated.

Mike