moderated Excel Formula
Steve & Shannon Cook <cookcafe@...>
Hi All,
Using Excel 2016, Windows 10 and the current version of JAWS. I have an Excel sheet in column A I have the task a person must perform. In Column B I will answer yes or no if they can perform the task. Here is my issue, I want to create a formula at the bottom of column B to determine if they answered yes to 80% of the questions. I would greatly appreciate your assistance!
Steve




Tanguy LOHEAC
Hi Steve, Sorry, i'm French, then I don't know exact function names in English. But i'll try to guide to the right path: To get the number of "yes" from column B the formula is something
like that =nb.if(b2:b10;"yes") where b2:b10 is the range of rows you want to sum and "yes" is what you want to sum. Then, to get the total number of tasks that are in column A this is: =sub.total(3;a:a)1 : here i'm not sure about the name but you may find it from the Math category. Then fi you want a percentage this is first divided by second as follows: =nb.if(b2:b10;"yes") / (sub.total(3;a:a)1)
Hope that helps anyway Tanguy
Le 26/06/2019 à 01:17, Steve &
Shannon Cook a écrit :





Russell Solowoniuk
Hi Steve,
toggle quoted messageShow quoted text
Let’s say you have Yes or no in cells B2 to B100. In cell B101, or wherever you wish, type the formula, CountIf(B2:B100,”Yes”). This will give you the number of cells with “Yes” in them. Then, in B102, or whoever you wish, type the formula, =CountA(B2:B100) Note the letter “A” after “Count” in the above formula. This will give you the total number of cells in column B that have data. Now, to calculate the percentage of cells with “Yes” in them, in cell B103, or wherever, type the formula, =B101/B102 You are dividing the number of “Yes” by the total number of cells with data. You will get a number like 0.67 or something like that. Press CTRL + 1 while in that cell and change the number formatting to Percentage, choose the number of decimal places you wish to show, and tab to OK. Hope this helps. Russell




Van Lant, Robin
I agree with Russell’s approach. That is exactly how I would do it. Technically you can combine both of the formulas into one cell, but I tend to like to show the results of each count in a different cell.
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of
Russell Solowoniuk
Sent: Wednesday, June 26, 2019 8:53 AM To: main@jfw.groups.io Subject: Re: Excel Formula
Hi Steve,
Let’s say you have Yes or no in cells B2 to B100. In cell B101, or wherever you wish, type the formula, CountIf(B2:B100,”Yes”). This will give you the number of cells with “Yes” in them. Then, in B102, or whoever you wish, type the formula, =CountA(B2:B100) Note the letter “A” after “Count” in the above formula. This will give you the total number of cells in column B that have data. Now, to calculate the percentage of cells with “Yes” in them, in cell B103, or wherever, type the formula, =B101/B102 You are dividing the number of “Yes” by the total number of cells with data. You will get a number like 0.67 or something like that. Press CTRL + 1 while in that cell and change the number formatting to Percentage, choose the number of decimal places you wish to show, and tab to OK.
Hope this helps.
Russell
This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. This communication may contain nonpublic personal information about consumers subject to the restrictions of the GrammLeachBliley Act. You may not directly or indirectly reuse or redisclose such information for any purpose other than to provide the services for which you are receiving the information. 127 Public Square, Cleveland, OH 44114




Richard Turner
I’m not sure why Russell’s instructions didn’t work for me, but I did the following and it worked. In b101: =COUNTIF(B2:B100,"Yes") IN b102, =COUNTA(B2:B100) In b103, =B101/B102
To test this, I put a Yes in b2 and No in b100. I got 1 as the result of yes’s, 2 in the result for number of cells with data in b102, and .50 in b103 which then switching the number type to percent, got 50.00. I did not bother changing the decimal places from the default.
HTH, Richard
Check out my web site at: www.turner42.com “The Hitch Hiker's Guide to the Galaxy has this to say on the subject of flying. There is an art, it says, or rather, a knack to flying. The knack lies in learning how to throw yourself at the ground and miss." Douglas Adams, from Life, The Universe and Everything, p.59
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of
Russell Solowoniuk
Sent: Wednesday, June 26, 2019 7:53 AM To: main@jfw.groups.io Subject: Re: Excel Formula
Hi Steve,
Let’s say you have Yes or no in cells B2 to B100. In cell B101, or wherever you wish, type the formula, CountIf(B2:B100,”Yes”). This will give you the number of cells with “Yes” in them. Then, in B102, or whoever you wish, type the formula, =CountA(B2:B100) Note the letter “A” after “Count” in the above formula. This will give you the total number of cells in column B that have data. Now, to calculate the percentage of cells with “Yes” in them, in cell B103, or wherever, type the formula, =B101/B102 You are dividing the number of “Yes” by the total number of cells with data. You will get a number like 0.67 or something like that. Press CTRL + 1 while in that cell and change the number formatting to Percentage, choose the number of decimal places you wish to show, and tab to OK.
Hope this helps.
Russell




Russell Solowoniuk
Hi Richard,
toggle quoted messageShow quoted text
I see no difference in my steps and yours? :) Thanks, Russell




Mario
the smart quotes instead of strait quotes makes the difference.
toggle quoted messageShow quoted text
crazy, isn't it? but true, watch out for these idiosyncrasies.
 Original Message 
From: Richard Turner [mailto:richardturner42@outlook.com] To: main@jfw.groups.io <main@jfw.groups.io> Date: Wednesday, June 26, 2019, 12:02 PM Subject: Excel Formula I’m not sure why Russell’s instructions didn’t work for me, but I did the following and it worked. In b101: =COUNTIF(B2:B100,"Yes") IN b102, =COUNTA(B2:B100) In b103, =B101/B102 To test this, I put a Yes in b2 and No in b100. I got 1 as the result of yes’s, 2 in the result for number of cells with data in b102, and .50 in b103 which then switching the number type to percent, got 50.00. I did not bother changing the decimal places from the default. HTH, Richard Check out my web site at: www.turner42.com<http://www.turner42.com> “The Hitch Hiker's Guide to the Galaxy has this to say on the subject of flying. There is an art, it says, or rather, a knack to flying. The knack lies in learning how to throw yourself at the ground and miss." Douglas Adams, from Life, The Universe and Everything, p.59 From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell Solowoniuk Sent: Wednesday, June 26, 2019 7:53 AM To: main@jfw.groups.io Subject: Re: Excel Formula Hi Steve, Let’s say you have Yes or no in cells B2 to B100. In cell B101, or wherever you wish, type the formula, CountIf(B2:B100,”Yes”). This will give you the number of cells with “Yes” in them. Then, in B102, or whoever you wish, type the formula, =CountA(B2:B100) Note the letter “A” after “Count” in the above formula. This will give you the total number of cells in column B that have data. Now, to calculate the percentage of cells with “Yes” in them, in cell B103, or wherever, type the formula, =B101/B102 You are dividing the number of “Yes” by the total number of cells with data. You will get a number like 0.67 or something like that. Press CTRL + 1 while in that cell and change the number formatting to Percentage, choose the number of decimal places you wish to show, and tab to OK. Hope this helps. Russell On Jun 25, 2019, at 5:17 PM, Steve & Shannon Cook <cookcafe@sc.rr.com<mailto:cookcafe@sc.rr.com>> wrote: Hi All, Using Excel 2016, Windows 10 and the current version of JAWS. I have an Excel sheet in column A I have the task a person must perform. In Column B I will answer yes or no if they can perform the task. Here is my issue, I want to create a formula at the bottom of column B to determine if they answered yes to 80% of the questions. I would greatly appreciate your assistance! Steve




Richard Turner
So Mario, which one has smart quotes?
toggle quoted messageShow quoted text
Jaws speaks them the same to me. Richard Check out my web site at: www.turner42.com “The Hitch Hiker's Guide to the Galaxy has this to say on the subject of flying. There is an art, it says, or rather, a knack to flying. The knack lies in learning how to throw yourself at the ground and miss." Douglas Adams, from Life, The Universe and Everything, p.59
Original Message
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Mario Sent: Wednesday, June 26, 2019 9:24 AM To: main@jfw.groups.io Subject: Re: Excel Formula the smart quotes instead of strait quotes makes the difference. crazy, isn't it? but true, watch out for these idiosyncrasies.  Original Message  From: Richard Turner [mailto:richardturner42@outlook.com] To: main@jfw.groups.io <main@jfw.groups.io> Date: Wednesday, June 26, 2019, 12:02 PM Subject: Excel Formula I’m not sure why Russell’s instructions didn’t work for me, but I did the following and it worked. In b101: =COUNTIF(B2:B100,"Yes") IN b102, =COUNTA(B2:B100) In b103, =B101/B102 To test this, I put a Yes in b2 and No in b100. I got 1 as the result of yes’s, 2 in the result for number of cells with data in b102, and .50 in b103 which then switching the number type to percent, got 50.00. I did not bother changing the decimal places from the default. HTH, Richard Check out my web site at: https://eur02.safelinks.protection.outlook.com/?url=www.turner42.com&;data=02%7C01%7C%7C0d3d893b497f40b286ef08d6fa52afb0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971630370466862&sdata=t4P9ngoprfyq5VkbYdTfOzNj8%2FyhMepM2dlNI0nWQVQ%3D&reserved=0<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.turner42.com&;data=02%7C01%7C%7C0d3d893b497f40b286ef08d6fa52afb0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971630370466862&sdata=wSbsazxpgdNeSTKDzjt9QKMsjIz8fSIlQexyjLq%2BEcE%3D&reserved=0> “The Hitch Hiker's Guide to the Galaxy has this to say on the subject of flying. There is an art, it says, or rather, a knack to flying. The knack lies in learning how to throw yourself at the ground and miss." Douglas Adams, from Life, The Universe and Everything, p.59 From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell Solowoniuk Sent: Wednesday, June 26, 2019 7:53 AM To: main@jfw.groups.io Subject: Re: Excel Formula Hi Steve, Let’s say you have Yes or no in cells B2 to B100. In cell B101, or wherever you wish, type the formula, CountIf(B2:B100,”Yes”). This will give you the number of cells with “Yes” in them. Then, in B102, or whoever you wish, type the formula, =CountA(B2:B100) Note the letter “A” after “Count” in the above formula. This will give you the total number of cells in column B that have data. Now, to calculate the percentage of cells with “Yes” in them, in cell B103, or wherever, type the formula, =B101/B102 You are dividing the number of “Yes” by the total number of cells with data. You will get a number like 0.67 or something like that. Press CTRL + 1 while in that cell and change the number formatting to Percentage, choose the number of decimal places you wish to show, and tab to OK. Hope this helps. Russell On Jun 25, 2019, at 5:17 PM, Steve & Shannon Cook <cookcafe@sc.rr.com<mailto:cookcafe@sc.rr.com>> wrote: Hi All, Using Excel 2016, Windows 10 and the current version of JAWS. I have an Excel sheet in column A I have the task a person must perform. In Column B I will answer yes or no if they can perform the task. Here is my issue, I want to create a formula at the bottom of column B to determine if they answered yes to 80% of the questions. I would greatly appreciate your assistance! Steve




Mario
left quotes and right quotes ar smart quotes. for example, left quote, I
toggle quoted messageShow quoted text
said that, right quote. the quotes are rarely referred to as curly quotes. the left quote is actually like or close to a smaller left parenthesis with a water droplet on the top half of the symbol pointing down, and the right quote is a smaller version of the right parenthesis with a water droplet at the bottom half of the symbol pointing up. in both symbols, the water droplet is a part of the left or right small parenthesis. the concept is, the left quote marks the opening to what someone said, and the right quote is the closing of what someone said.
 Original Message 
From: Richard Turner [mailto:richardturner42@outlook.com] To: main@jfw.groups.io <main@jfw.groups.io> Date: Wednesday, June 26, 2019, 12:30 PM Subject: Excel Formula So Mario, which one has smart quotes? Jaws speaks them the same to me. Richard Check out my web site at: www.turner42.com “The Hitch Hiker's Guide to the Galaxy has this to say on the subject of flying. There is an art, it says, or rather, a knack to flying. The knack lies in learning how to throw yourself at the ground and miss." Douglas Adams, from Life, The Universe and Everything, p.59 Original Message From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Mario Sent: Wednesday, June 26, 2019 9:24 AM To: main@jfw.groups.io Subject: Re: Excel Formula the smart quotes instead of strait quotes makes the difference. crazy, isn't it? but true, watch out for these idiosyncrasies.  Original Message  From: Richard Turner [mailto:richardturner42@outlook.com] To: main@jfw.groups.io <main@jfw.groups.io> Date: Wednesday, June 26, 2019, 12:02 PM Subject: Excel Formula I’m not sure why Russell’s instructions didn’t work for me, but I did the following and it worked. In b101: =COUNTIF(B2:B100,"Yes") IN b102, =COUNTA(B2:B100) In b103, =B101/B102 To test this, I put a Yes in b2 and No in b100. I got 1 as the result of yes’s, 2 in the result for number of cells with data in b102, and .50 in b103 which then switching the number type to percent, got 50.00. I did not bother changing the decimal places from the default. HTH, Richard Check out my web site at: https://eur02.safelinks.protection.outlook.com/?url=www.turner42.com&;data=02%7C01%7C%7C0d3d893b497f40b286ef08d6fa52afb0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971630370466862&sdata=t4P9ngoprfyq5VkbYdTfOzNj8%2FyhMepM2dlNI0nWQVQ%3D&reserved=0<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.turner42.com&;data=02%7C01%7C%7C0d3d893b497f40b286ef08d6fa52afb0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971630370466862&sdata=wSbsazxpgdNeSTKDzjt9QKMsjIz8fSIlQexyjLq%2BEcE%3D&reserved=0> “The Hitch Hiker's Guide to the Galaxy has this to say on the subject of flying. There is an art, it says, or rather, a knack to flying. The knack lies in learning how to throw yourself at the ground and miss." Douglas Adams, from Life, The Universe and Everything, p.59 From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell Solowoniuk Sent: Wednesday, June 26, 2019 7:53 AM To: main@jfw.groups.io Subject: Re: Excel Formula Hi Steve, Let’s say you have Yes or no in cells B2 to B100. In cell B101, or wherever you wish, type the formula, CountIf(B2:B100,”Yes”). This will give you the number of cells with “Yes” in them. Then, in B102, or whoever you wish, type the formula, =CountA(B2:B100) Note the letter “A” after “Count” in the above formula. This will give you the total number of cells in column B that have data. Now, to calculate the percentage of cells with “Yes” in them, in cell B103, or wherever, type the formula, =B101/B102 You are dividing the number of “Yes” by the total number of cells with data. You will get a number like 0.67 or something like that. Press CTRL + 1 while in that cell and change the number formatting to Percentage, choose the number of decimal places you wish to show, and tab to OK. Hope this helps. Russell On Jun 25, 2019, at 5:17 PM, Steve & Shannon Cook <cookcafe@sc.rr.com<mailto:cookcafe@sc.rr.com>> wrote: Hi All, Using Excel 2016, Windows 10 and the current version of JAWS. I have an Excel sheet in column A I have the task a person must perform. In Column B I will answer yes or no if they can perform the task. Here is my issue, I want to create a formula at the bottom of column B to determine if they answered yes to 80% of the questions. I would greatly appreciate your assistance! Steve




Richard Turner
I know what they are, but you did not say if Russell had smart quotes or if I had smart quotes.
toggle quoted messageShow quoted text
I'm blind and Jaws said the exact same thing in reading both versions. You stated pretty straight forwardly that the smart quotes was the issue... Not helpful unless we know which version had the smart quotes. Thanks, Richard Check out my web site at: www.turner42.com “The Hitch Hiker's Guide to the Galaxy has this to say on the subject of flying. There is an art, it says, or rather, a knack to flying. The knack lies in learning how to throw yourself at the ground and miss." Douglas Adams, from Life, The Universe and Everything, p.59
Original Message
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Mario Sent: Wednesday, June 26, 2019 9:58 AM To: main@jfw.groups.io Subject: Re: Excel Formula left quotes and right quotes ar smart quotes. for example, left quote, I said that, right quote. the quotes are rarely referred to as curly quotes. the left quote is actually like or close to a smaller left parenthesis with a water droplet on the top half of the symbol pointing down, and the right quote is a smaller version of the right parenthesis with a water droplet at the bottom half of the symbol pointing up. in both symbols, the water droplet is a part of the left or right small parenthesis. the concept is, the left quote marks the opening to what someone said, and the right quote is the closing of what someone said.  Original Message  From: Richard Turner [mailto:richardturner42@outlook.com] To: main@jfw.groups.io <main@jfw.groups.io> Date: Wednesday, June 26, 2019, 12:30 PM Subject: Excel Formula So Mario, which one has smart quotes? Jaws speaks them the same to me. Richard Check out my web site at: https://nam01.safelinks.protection.outlook.com/?url=www.turner42.com&;data=02%7C01%7C%7C57cb9d9db0d04a5c3f6708d6fa57650d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971650591002154&sdata=7i9qEP%2FCUNz71CxoI3cjdNbH5jXkDEIU4XETbocdmks%3D&reserved=0 “The Hitch Hiker's Guide to the Galaxy has this to say on the subject of flying. There is an art, it says, or rather, a knack to flying. The knack lies in learning how to throw yourself at the ground and miss." Douglas Adams, from Life, The Universe and Everything, p.59 Original Message From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Mario Sent: Wednesday, June 26, 2019 9:24 AM To: main@jfw.groups.io Subject: Re: Excel Formula the smart quotes instead of strait quotes makes the difference. crazy, isn't it? but true, watch out for these idiosyncrasies.  Original Message  From: Richard Turner [mailto:richardturner42@outlook.com] To: main@jfw.groups.io <main@jfw.groups.io> Date: Wednesday, June 26, 2019, 12:02 PM Subject: Excel Formula I’m not sure why Russell’s instructions didn’t work for me, but I did the following and it worked. In b101: =COUNTIF(B2:B100,"Yes") IN b102, =COUNTA(B2:B100) In b103, =B101/B102 To test this, I put a Yes in b2 and No in b100. I got 1 as the result of yes’s, 2 in the result for number of cells with data in b102, and .50 in b103 which then switching the number type to percent, got 50.00. I did not bother changing the decimal places from the default. HTH, Richard Check out my web site at: https://nam01.safelinks.protection.outlook.com/?url=www.turner42.com&;data=02%7C01%7C%7C57cb9d9db0d04a5c3f6708d6fa57650d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971650591002154&sdata=7i9qEP%2FCUNz71CxoI3cjdNbH5jXkDEIU4XETbocdmks%3D&reserved=0<https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.turner42.com&;data=02%7C01%7C%7C57cb9d9db0d04a5c3f6708d6fa57650d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971650591002154&sdata=oO3mhEA78GdSJnFW5qzx%2BYYEqmYsU585yjesDnuvKWU%3D&reserved=0> “The Hitch Hiker's Guide to the Galaxy has this to say on the subject of flying. There is an art, it says, or rather, a knack to flying. The knack lies in learning how to throw yourself at the ground and miss." Douglas Adams, from Life, The Universe and Everything, p.59 From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell Solowoniuk Sent: Wednesday, June 26, 2019 7:53 AM To: main@jfw.groups.io Subject: Re: Excel Formula Hi Steve, Let’s say you have Yes or no in cells B2 to B100. In cell B101, or wherever you wish, type the formula, CountIf(B2:B100,”Yes”). This will give you the number of cells with “Yes” in them. Then, in B102, or whoever you wish, type the formula, =CountA(B2:B100) Note the letter “A” after “Count” in the above formula. This will give you the total number of cells in column B that have data. Now, to calculate the percentage of cells with “Yes” in them, in cell B103, or wherever, type the formula, =B101/B102 You are dividing the number of “Yes” by the total number of cells with data. You will get a number like 0.67 or something like that. Press CTRL + 1 while in that cell and change the number formatting to Percentage, choose the number of decimal places you wish to show, and tab to OK. Hope this helps. Russell On Jun 25, 2019, at 5:17 PM, Steve & Shannon Cook <cookcafe@sc.rr.com<mailto:cookcafe@sc.rr.com>> wrote: Hi All, Using Excel 2016, Windows 10 and the current version of JAWS. I have an Excel sheet in column A I have the task a person must perform. In Column B I will answer yes or no if they can perform the task. Here is my issue, I want to create a formula at the bottom of column B to determine if they answered yes to 80% of the questions. I would greatly appreciate your assistance! Steve




Russell Solowoniuk
Hi Richard,
toggle quoted messageShow quoted text
I think I have “smart quotes” in my instructions. I typed the instructions from Mail on my iMac, and, when I read your quotes VoiceOver reads Quote yes quote and in my instructions, VoiceOver reads right double quote Yes right double quote. Yes, it reads right double quote for both! :) Thanks Mario for catching the differences, and apology Richard! Russell
On Jun 26, 2019, at 11:02 AM, Richard Turner <richardturner42@outlook.com> wrote:




Richard Turner
Thanks Russell, that makes sense.
toggle quoted messageShow quoted text
You will find too, that if you search for books with an apostrophe in the title, the smart single quote, which is supposed to be the apostrophe won't return any results. I found this both with BARD and with Bookshare. Richard Check out my web site at: www.turner42.com “The Hitch Hiker's Guide to the Galaxy has this to say on the subject of flying. There is an art, it says, or rather, a knack to flying. The knack lies in learning how to throw yourself at the ground and miss." Douglas Adams, from Life, The Universe and Everything, p.59
Original Message
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell Solowoniuk Sent: Wednesday, June 26, 2019 10:15 AM To: main@jfw.groups.io Subject: Re: Excel Formula Hi Richard, I think I have “smart quotes” in my instructions. I typed the instructions from Mail on my iMac, and, when I read your quotes VoiceOver reads Quote yes quote and in my instructions, VoiceOver reads right double quote Yes right double quote. Yes, it reads right double quote for both! :) Thanks Mario for catching the differences, and apology Richard! Russell On Jun 26, 2019, at 11:02 AM, Richard Turner <richardturner42@outlook.com> wrote:




Russell Solowoniuk
Hi Richard,
toggle quoted messageShow quoted text
Good to know. I just turned off "Smart Quotes" in System Preferences on my iMac, so all should be well now... hopefully! :) Thanks, Russell
On Jun 26, 2019, at 11:45 AM, Richard Turner <richardturner42@outlook.com> wrote:




John Covici
How do you type these smart quotes?
On Wed, 26 Jun 2019 12:57:34 0400, Mario wrote:  Your life is like a penny. You're going to lose it. The question is: How do you spend it? John Covici wb2una covici@ccs.covici.com




Russell Solowoniuk
Hi John,
toggle quoted messageShow quoted text
On my iMac there's a setting in Keyboard settings to use Smart Quotes and Dashes. It's either checked or unchecked. If it's checked, when you type a quote, it's automatically changed to a Smart Quote. Not sure how to do this in Windows... I think it's a setting within Outlook. Thanks, Russell
On Jun 26, 2019, at 12:07 PM, John Covici <covici@ccs.covici.com> wrote:




Mario
well, I was responding to your inquiry that you didn't know why Russel's
toggle quoted messageShow quoted text
formula wasn't working. but the quotes that surrounded the word Yes in your response are straight quotes. if they are smart quotes, JAWS would say left quote followed by the quote followed by saying right quote. if JAWS just says quote followed by the quote followed by quote, those are straight quotes. hope it's clearer.
 Original Message 
From: Richard Turner [mailto:richardturner42@outlook.com] To: main@jfw.groups.io <main@jfw.groups.io> Date: Wednesday, June 26, 2019, 1:02 PM Subject: Excel Formula I know what they are, but you did not say if Russell had smart quotes or if I had smart quotes. I'm blind and Jaws said the exact same thing in reading both versions. You stated pretty straight forwardly that the smart quotes was the issue... Not helpful unless we know which version had the smart quotes. Thanks, Richard Check out my web site at: www.turner42.com “The Hitch Hiker's Guide to the Galaxy has this to say on the subject of flying. There is an art, it says, or rather, a knack to flying. The knack lies in learning how to throw yourself at the ground and miss." Douglas Adams, from Life, The Universe and Everything, p.59 Original Message From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Mario Sent: Wednesday, June 26, 2019 9:58 AM To: main@jfw.groups.io Subject: Re: Excel Formula left quotes and right quotes ar smart quotes. for example, left quote, I said that, right quote. the quotes are rarely referred to as curly quotes. the left quote is actually like or close to a smaller left parenthesis with a water droplet on the top half of the symbol pointing down, and the right quote is a smaller version of the right parenthesis with a water droplet at the bottom half of the symbol pointing up. in both symbols, the water droplet is a part of the left or right small parenthesis. the concept is, the left quote marks the opening to what someone said, and the right quote is the closing of what someone said.  Original Message  From: Richard Turner [mailto:richardturner42@outlook.com] To: main@jfw.groups.io <main@jfw.groups.io> Date: Wednesday, June 26, 2019, 12:30 PM Subject: Excel Formula So Mario, which one has smart quotes? Jaws speaks them the same to me. Richard Check out my web site at: https://nam01.safelinks.protection.outlook.com/?url=www.turner42.com&;data=02%7C01%7C%7C57cb9d9db0d04a5c3f6708d6fa57650d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971650591002154&sdata=7i9qEP%2FCUNz71CxoI3cjdNbH5jXkDEIU4XETbocdmks%3D&reserved=0 “The Hitch Hiker's Guide to the Galaxy has this to say on the subject of flying. There is an art, it says, or rather, a knack to flying. The knack lies in learning how to throw yourself at the ground and miss." Douglas Adams, from Life, The Universe and Everything, p.59 Original Message From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Mario Sent: Wednesday, June 26, 2019 9:24 AM To: main@jfw.groups.io Subject: Re: Excel Formula the smart quotes instead of strait quotes makes the difference. crazy, isn't it? but true, watch out for these idiosyncrasies.  Original Message  From: Richard Turner [mailto:richardturner42@outlook.com] To: main@jfw.groups.io <main@jfw.groups.io> Date: Wednesday, June 26, 2019, 12:02 PM Subject: Excel Formula I’m not sure why Russell’s instructions didn’t work for me, but I did the following and it worked. In b101: =COUNTIF(B2:B100,"Yes") IN b102, =COUNTA(B2:B100) In b103, =B101/B102 To test this, I put a Yes in b2 and No in b100. I got 1 as the result of yes’s, 2 in the result for number of cells with data in b102, and .50 in b103 which then switching the number type to percent, got 50.00. I did not bother changing the decimal places from the default. HTH, Richard Check out my web site at: https://nam01.safelinks.protection.outlook.com/?url=www.turner42.com&;data=02%7C01%7C%7C57cb9d9db0d04a5c3f6708d6fa57650d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971650591002154&sdata=7i9qEP%2FCUNz71CxoI3cjdNbH5jXkDEIU4XETbocdmks%3D&reserved=0<https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.turner42.com&;data=02%7C01%7C%7C57cb9d9db0d04a5c3f6708d6fa57650d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971650591002154&sdata=oO3mhEA78GdSJnFW5qzx%2BYYEqmYsU585yjesDnuvKWU%3D&reserved=0> “The Hitch Hiker's Guide to the Galaxy has this to say on the subject of flying. There is an art, it says, or rather, a knack to flying. The knack lies in learning how to throw yourself at the ground and miss." Douglas Adams, from Life, The Universe and Everything, p.59 From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell Solowoniuk Sent: Wednesday, June 26, 2019 7:53 AM To: main@jfw.groups.io Subject: Re: Excel Formula Hi Steve, Let’s say you have Yes or no in cells B2 to B100. In cell B101, or wherever you wish, type the formula, CountIf(B2:B100,”Yes”). This will give you the number of cells with “Yes” in them. Then, in B102, or whoever you wish, type the formula, =CountA(B2:B100) Note the letter “A” after “Count” in the above formula. This will give you the total number of cells in column B that have data. Now, to calculate the percentage of cells with “Yes” in them, in cell B103, or wherever, type the formula, =B101/B102 You are dividing the number of “Yes” by the total number of cells with data. You will get a number like 0.67 or something like that. Press CTRL + 1 while in that cell and change the number formatting to Percentage, choose the number of decimal places you wish to show, and tab to OK. Hope this helps. Russell On Jun 25, 2019, at 5:17 PM, Steve & Shannon Cook <cookcafe@sc.rr.com<mailto:cookcafe@sc.rr.com>> wrote: Hi All, Using Excel 2016, Windows 10 and the current version of JAWS. I have an Excel sheet in column A I have the task a person must perform. In Column B I will answer yes or no if they can perform the task. Here is my issue, I want to create a formula at the bottom of column B to determine if they answered yes to 80% of the questions. I would greatly appreciate your assistance! Steve




Richard Turner
Thanks.
toggle quoted messageShow quoted text
It was just that in your first response, you didn't say whose formula had the smart quotes, but Russell clarified that his Mac was set to use smart quotes, which he has now turned off. It would be nice if Jaws said something different when it encounters smart quotes, but it doesn't. Later, Richard Check out my web site at: www.turner42.com “The Hitch Hiker's Guide to the Galaxy has this to say on the subject of flying. There is an art, it says, or rather, a knack to flying. The knack lies in learning how to throw yourself at the ground and miss." Douglas Adams, from Life, The Universe and Everything, p.59
Original Message
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Mario Sent: Wednesday, June 26, 2019 12:11 PM To: main@jfw.groups.io Subject: Re: Excel Formula well, I was responding to your inquiry that you didn't know why Russel's formula wasn't working. but the quotes that surrounded the word Yes in your response are straight quotes. if they are smart quotes, JAWS would say left quote followed by the quote followed by saying right quote. if JAWS just says quote followed by the quote followed by quote, those are straight quotes. hope it's clearer.  Original Message  From: Richard Turner [mailto:richardturner42@outlook.com] To: main@jfw.groups.io <main@jfw.groups.io> Date: Wednesday, June 26, 2019, 1:02 PM Subject: Excel Formula I know what they are, but you did not say if Russell had smart quotes or if I had smart quotes. I'm blind and Jaws said the exact same thing in reading both versions. You stated pretty straight forwardly that the smart quotes was the issue... Not helpful unless we know which version had the smart quotes. Thanks, Richard Check out my web site at: https://eur04.safelinks.protection.outlook.com/?url=www.turner42.com&;data=02%7C01%7C%7Cae1db638f6db401a19e308d6fa6a1c0f%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971730973356581&sdata=RUCRgaCypNb8wLYUd%2Bn%2B57zTMdx4N71icY2ZGdTk0xo%3D&reserved=0 “The Hitch Hiker's Guide to the Galaxy has this to say on the subject of flying. There is an art, it says, or rather, a knack to flying. The knack lies in learning how to throw yourself at the ground and miss." Douglas Adams, from Life, The Universe and Everything, p.59 Original Message From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Mario Sent: Wednesday, June 26, 2019 9:58 AM To: main@jfw.groups.io Subject: Re: Excel Formula left quotes and right quotes ar smart quotes. for example, left quote, I said that, right quote. the quotes are rarely referred to as curly quotes. the left quote is actually like or close to a smaller left parenthesis with a water droplet on the top half of the symbol pointing down, and the right quote is a smaller version of the right parenthesis with a water droplet at the bottom half of the symbol pointing up. in both symbols, the water droplet is a part of the left or right small parenthesis. the concept is, the left quote marks the opening to what someone said, and the right quote is the closing of what someone said.  Original Message  From: Richard Turner [mailto:richardturner42@outlook.com] To: main@jfw.groups.io <main@jfw.groups.io> Date: Wednesday, June 26, 2019, 12:30 PM Subject: Excel Formula So Mario, which one has smart quotes? Jaws speaks them the same to me. Richard Check out my web site at: https://eur04.safelinks.protection.outlook.com/?url=www.turner42.com&;data=02%7C01%7C%7Cae1db638f6db401a19e308d6fa6a1c0f%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971730973356581&sdata=RUCRgaCypNb8wLYUd%2Bn%2B57zTMdx4N71icY2ZGdTk0xo%3D&reserved=0 “The Hitch Hiker's Guide to the Galaxy has this to say on the subject of flying. There is an art, it says, or rather, a knack to flying. The knack lies in learning how to throw yourself at the ground and miss." Douglas Adams, from Life, The Universe and Everything, p.59 Original Message From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Mario Sent: Wednesday, June 26, 2019 9:24 AM To: main@jfw.groups.io Subject: Re: Excel Formula the smart quotes instead of strait quotes makes the difference. crazy, isn't it? but true, watch out for these idiosyncrasies.  Original Message  From: Richard Turner [mailto:richardturner42@outlook.com] To: main@jfw.groups.io <main@jfw.groups.io> Date: Wednesday, June 26, 2019, 12:02 PM Subject: Excel Formula I’m not sure why Russell’s instructions didn’t work for me, but I did the following and it worked. In b101: =COUNTIF(B2:B100,"Yes") IN b102, =COUNTA(B2:B100) In b103, =B101/B102 To test this, I put a Yes in b2 and No in b100. I got 1 as the result of yes’s, 2 in the result for number of cells with data in b102, and .50 in b103 which then switching the number type to percent, got 50.00. I did not bother changing the decimal places from the default. HTH, Richard Check out my web site at: https://eur04.safelinks.protection.outlook.com/?url=www.turner42.com&;data=02%7C01%7C%7Cae1db638f6db401a19e308d6fa6a1c0f%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971730973356581&sdata=RUCRgaCypNb8wLYUd%2Bn%2B57zTMdx4N71icY2ZGdTk0xo%3D&reserved=0<https://eur04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.turner42.com&;data=02%7C01%7C%7Cae1db638f6db401a19e308d6fa6a1c0f%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971730973366593&sdata=JgNiw9G%2FKmQRAPK3XspE7UKUPGZVsPAiQTW9ZCQ%2FGJ0%3D&reserved=0> “The Hitch Hiker's Guide to the Galaxy has this to say on the subject of flying. There is an art, it says, or rather, a knack to flying. The knack lies in learning how to throw yourself at the ground and miss." Douglas Adams, from Life, The Universe and Everything, p.59 From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell Solowoniuk Sent: Wednesday, June 26, 2019 7:53 AM To: main@jfw.groups.io Subject: Re: Excel Formula Hi Steve, Let’s say you have Yes or no in cells B2 to B100. In cell B101, or wherever you wish, type the formula, CountIf(B2:B100,”Yes”). This will give you the number of cells with “Yes” in them. Then, in B102, or whoever you wish, type the formula, =CountA(B2:B100) Note the letter “A” after “Count” in the above formula. This will give you the total number of cells in column B that have data. Now, to calculate the percentage of cells with “Yes” in them, in cell B103, or wherever, type the formula, =B101/B102 You are dividing the number of “Yes” by the total number of cells with data. You will get a number like 0.67 or something like that. Press CTRL + 1 while in that cell and change the number formatting to Percentage, choose the number of decimal places you wish to show, and tab to OK. Hope this helps. Russell On Jun 25, 2019, at 5:17 PM, Steve & Shannon Cook <cookcafe@sc.rr.com<mailto:cookcafe@sc.rr.com>> wrote: Hi All, Using Excel 2016, Windows 10 and the current version of JAWS. I have an Excel sheet in column A I have the task a person must perform. In Column B I will answer yes or no if they can perform the task. Here is my issue, I want to create a formula at the bottom of column B to determine if they answered yes to 80% of the questions. I would greatly appreciate your assistance! Steve




On Wed, Jun 26, 2019 at 03:17 PM, Richard Turner wrote:
It would be nice if Jaws said something different when it encounters smart quotes, but it doesn't.Isn't there a way to control this via a dictionary at a specific level [as in only when speaking character by character]? That's a serious question, as I constantly get confused about what JAWS supports versus what NVDA supports and have flipflopped the two on more than one occasion.  Brian  Windows 10 Pro, 64Bit, Version 1809, Build 17763 Here is a test to find out whether your mission in life is complete. If you’re alive, it isn’t. ~ Lauren Bacall




Gudrun Brunot
John,: If you want to make sure, use the ASCII characters alt8220 for open
toggle quoted messageShow quoted text
quote, alt8221 for close quotes. Gudrun Please note my new email of brunotgudrun@gmail.com
Original Message
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of John Covici Sent: Wednesday, June 26, 2019 11:08 AM To: main@jfw.groups.io Subject: Re: Excel Formula How do you type these smart quotes? On Wed, 26 Jun 2019 12:57:34 0400, Mario wrote: quotes. the left quote is actually like or close to a smaller left parenthesisdata. You will get a number like 0.67 or something like that. Press CTRL + 1 Your life is like a penny. You're going to lose it. The question is: How do you spend it? John Covici wb2una covici@ccs.covici.com


