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?

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?

Excluding cell in formula
 

I don't inderstand what you mean by:

percentage for the calls and exclude these numbers?

Do you mean exclude the * and blank cells?

SUM() will ignore both * and a blank cell, (or any text in fact) so will not
simply SUMming the numbers and dividing by whatever you criteria is give you
the answer you want?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Ruben061479" wrote in message
...
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?

Excluding cell in formula
 

This Is the formula I am Currently using
=SUM(G2:O2)*20/9
there are actually 9 columns and the value are between 1-5
the issue is the blank cells and cells containing *(stars)
How can I make these cells either equal 0 or just not counted in the formula

"Ag" wrote:

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?

Excluding cell in formula
 

Yes

"Sandy Mann" wrote:

I don't inderstand what you mean by:

percentage for the calls and exclude these numbers?

Do you mean exclude the * and blank cells?

SUM() will ignore both * and a blank cell, (or any text in fact) so will not
simply SUMming the numbers and dividing by whatever you criteria is give you
the answer you want?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Ruben061479" wrote in message
...
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?