Hi,
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