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?
|