Excluding cell in formula

  • Thread starter Thread starter Ruben061479
  • Start date Start date
R

Ruben061479

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?
 
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
 
I don't inderstand what you mean by:
percentage for the calls and exclude these numbers?
Click to expand...

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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
 
Yes

Sandy Mann said:
I don't inderstand what you mean by:


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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
Click to expand...
 
Back
Top