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

Not sure about the worksheet structure as there appears to be 4 column
headings and 5 values however probably you can use the

=COUNTIF(J5:J10,"0") to determine non asterisk and no blank entries
and
=ROWS(J5:J10) to determine total responses
Post that with the above information any coumputation should be
possible


Regards
Anirudh

On Jan 13, 9:46*pm, Ruben061479
wrote:
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?