Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formula Minimum Excluding Text | Excel Discussion (Misc queries) | |||
how do i lookup the value of the next cell excluding the first lookedupresult | Excel Worksheet Functions | |||
Looking for formula for lowest costs, excluding zero | Excel Worksheet Functions | |||
Formula - Excluding weekends & holidays | Excel Worksheet Functions | |||
excluding cells from the formula when empty | Excel Worksheet Functions |