View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ruben061479 Ruben061479 is offline
external usenet poster
 
Posts: 5
Default Excluding cell in formula

I have a worksheet as a result of customer surveys but the customer is
allowed to press * to skip he question or leave blank, how can I get the
percentage for the calls and exclude these numbers?

example

Driver protect come back overall
percentage

Paulo * 5
5 ?
Rolando 5 5 5
100%
Kane 5 5
?

How can I make this work?
Can anybody help me?