Date   
moderated Re: Excel Formula

Richard Turner
 

Thanks.
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@...]
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&amp;data=02%7C01%7C%7Cae1db638f6db401a19e308d6fa6a1c0f%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971730973356581&amp;sdata=RUCRgaCypNb8wLYUd%2Bn%2B57zTMdx4N71icY2ZGdTk0xo%3D&amp;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@...]
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&amp;data=02%7C01%7C%7Cae1db638f6db401a19e308d6fa6a1c0f%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971730973356581&amp;sdata=RUCRgaCypNb8wLYUd%2Bn%2B57zTMdx4N71icY2ZGdTk0xo%3D&amp;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@...]
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&amp;data=02%7C01%7C%7Cae1db638f6db401a19e308d6fa6a1c0f%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971730973356581&amp;sdata=RUCRgaCypNb8wLYUd%2Bn%2B57zTMdx4N71icY2ZGdTk0xo%3D&amp;reserved=0<https://eur04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.turner42.com&amp;data=02%7C01%7C%7Cae1db638f6db401a19e308d6fa6a1c0f%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971730973366593&amp;sdata=JgNiw9G%2FKmQRAPK3XspE7UKUPGZVsPAiQTW9ZCQ%2FGJ0%3D&amp;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@...<mailto:cookcafe@...>> 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

moderated Re: Excel Formula

Mario
 

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@...]
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@...]
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&amp;data=02%7C01%7C%7C57cb9d9db0d04a5c3f6708d6fa57650d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971650591002154&amp;sdata=7i9qEP%2FCUNz71CxoI3cjdNbH5jXkDEIU4XETbocdmks%3D&amp;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@...]
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&amp;data=02%7C01%7C%7C57cb9d9db0d04a5c3f6708d6fa57650d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971650591002154&amp;sdata=7i9qEP%2FCUNz71CxoI3cjdNbH5jXkDEIU4XETbocdmks%3D&amp;reserved=0<https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.turner42.com&amp;data=02%7C01%7C%7C57cb9d9db0d04a5c3f6708d6fa57650d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971650591002154&amp;sdata=oO3mhEA78GdSJnFW5qzx%2BYYEqmYsU585yjesDnuvKWU%3D&amp;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@...<mailto:cookcafe@...>> 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

moderated Re: Fire fox Tutorial

JM Casey
 

No, but the firefox help system is allright and should be a benefit to you if you need it. Do you have any specific questions?

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Kevin Stone
Sent: June 25, 2019 9:30 PM
To: jfw@groups.io
Subject: Fire fox Tutorial

 

Does anyone know of a tutorial for fire fox?  Thanks in advance

 

Kevin Stone

moderated Re: Excel Formula

Russell Solowoniuk
 

Hi John,

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@...> wrote:

How do you type these smart quotes?

On Wed, 26 Jun 2019 12:57:34 -0400,
Mario wrote:

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@...]
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@...]
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&amp;data=02%7C01%7C%7C0d3d893b497f40b286ef08d6fa52afb0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971630370466862&amp;sdata=t4P9ngoprfyq5VkbYdTfOzNj8%2FyhMepM2dlNI0nWQVQ%3D&amp;reserved=0<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.turner42.com&amp;data=02%7C01%7C%7C0d3d893b497f40b286ef08d6fa52afb0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971630370466862&amp;sdata=wSbsazxpgdNeSTKDzjt9QKMsjIz8fSIlQexyjLq%2BEcE%3D&amp;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@...<mailto:cookcafe@...>> 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

















--
Your life is like a penny. You're going to lose it. The question is:
How do
you spend it?

John Covici wb2una
covici@...


moderated Re: JAWS 18, Chrome, and Oracle applications

Chris Hill
 

Yes, all browsers do.  In chrome, hit jaws+v to open the settings, type refr in the box, hit tab and you should be able to change the refresh setting from automatic, 60 seconds or off if your version is like Jaws 19, which I believe it is.



On 6/26/2019 13:00, John Doering wrote:

Hello:

At work we use JAWS 18 and Chrome to access Oracle applications.

For the past few days we have been experiencing an annoyance where when working down a web page either by arrowing down or using something else like by headings, we will get stuck in a section of a page.  You will go down so far, then be popped back up to the start of the section or page.

I think it may be caused by the page refreshing itself every 5 seconds.

Does Chrome automatically refresh itself at regular intervals and if so, can this be adjusted?

Any help or thoughts will be appreciated.

Thanks in advance.

 

John

 

moderated Re: Excel Formula

John Covici
 

How do you type these smart quotes?

On Wed, 26 Jun 2019 12:57:34 -0400,
Mario wrote:

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@...]
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@...]
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&amp;data=02%7C01%7C%7C0d3d893b497f40b286ef08d6fa52afb0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971630370466862&amp;sdata=t4P9ngoprfyq5VkbYdTfOzNj8%2FyhMepM2dlNI0nWQVQ%3D&amp;reserved=0<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.turner42.com&amp;data=02%7C01%7C%7C0d3d893b497f40b286ef08d6fa52afb0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971630370466862&amp;sdata=wSbsazxpgdNeSTKDzjt9QKMsjIz8fSIlQexyjLq%2BEcE%3D&amp;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@...<mailto:cookcafe@...>> 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

















--
Your life is like a penny. You're going to lose it. The question is:
How do
you spend it?

John Covici wb2una
covici@...

moderated Re: JAWS 18, Chrome, and Oracle applications

Rick Mladek
 

Hi John,

 

I notice this on IE and Firefox, as well.

 

Rick

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of John Doering
Sent: Wednesday, June 26, 2019 2:01 PM
To: main@jfw.groups.io
Subject: JAWS 18, Chrome, and Oracle applications

 

Hello:

At work we use JAWS 18 and Chrome to access Oracle applications.

For the past few days we have been experiencing an annoyance where when working down a web page either by arrowing down or using something else like by headings, we will get stuck in a section of a page.  You will go down so far, then be popped back up to the start of the section or page.

I think it may be caused by the page refreshing itself every 5 seconds.

Does Chrome automatically refresh itself at regular intervals and if so, can this be adjusted?

Any help or thoughts will be appreciated.

Thanks in advance.

 

John

 

moderated Re: Excel Formula

Russell Solowoniuk
 

Hi Richard,

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@...> wrote:

Thanks Russell, that makes sense.
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@...> wrote:

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://eur01.safelinks.protection.outlook.com/?url=www.turner42.com&a
mp;data=02%7C01%7C%7Cdf65836c80724301fcb708d6fa59d66a%7C84df9e7fe9f640
afb435aaaaaaaaaaaa%7C1%7C0%7C636971661089453948&amp;sdata=o95u86m%2BeZ
9gMuph8ujXS04kZOcldtwmO25%2BrAzVT44%3D&amp;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@...]
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://eur01.safelinks.protection.outlook.com/?url=www.turner42.com&a
mp;data=02%7C01%7C%7Cdf65836c80724301fcb708d6fa59d66a%7C84df9e7fe9f640
afb435aaaaaaaaaaaa%7C1%7C0%7C636971661089463959&amp;sdata=tCdDcf%2F6ME
1JKCH0qmq1pVpj99%2FwC2V5ki46P6Pasho%3D&amp;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@...]
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://eur01.safelinks.protection.outlook.com/?url=www.turner42.com&a
mp;data=02%7C01%7C%7Cdf65836c80724301fcb708d6fa59d66a%7C84df9e7fe9f640
afb435aaaaaaaaaaaa%7C1%7C0%7C636971661089463959&amp;sdata=tCdDcf%2F6ME
1JKCH0qmq1pVpj99%2FwC2V5ki46P6Pasho%3D&amp;reserved=0<https://eur01.sa
felinks.protection.outlook.com/?url=http%3A%2F%2Fwww.turner42.com&amp;
data=02%7C01%7C%7Cdf65836c80724301fcb708d6fa59d66a%7C84df9e7fe9f640afb
435aaaaaaaaaaaa%7C1%7C0%7C636971661089463959&amp;sdata=LE6c84CbTDjQLkm
haQkoDoE4xVd59Cn5DSI%2BZ1RVprY%3D&amp;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@...<mailto:cookcafe@...>> 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
























moderated JAWS 18, Chrome, and Oracle applications

John Doering
 

Hello:

At work we use JAWS 18 and Chrome to access Oracle applications.

For the past few days we have been experiencing an annoyance where when working down a web page either by arrowing down or using something else like by headings, we will get stuck in a section of a page.  You will go down so far, then be popped back up to the start of the section or page.

I think it may be caused by the page refreshing itself every 5 seconds.

Does Chrome automatically refresh itself at regular intervals and if so, can this be adjusted?

Any help or thoughts will be appreciated.

Thanks in advance.

 

John

 

moderated Re: Excel Formula

Richard Turner
 

Thanks Russell, that makes sense.
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@...> wrote:

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://eur01.safelinks.protection.outlook.com/?url=www.turner42.com&a
mp;data=02%7C01%7C%7Cdf65836c80724301fcb708d6fa59d66a%7C84df9e7fe9f640
afb435aaaaaaaaaaaa%7C1%7C0%7C636971661089453948&amp;sdata=o95u86m%2BeZ
9gMuph8ujXS04kZOcldtwmO25%2BrAzVT44%3D&amp;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@...]
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://eur01.safelinks.protection.outlook.com/?url=www.turner42.com&a
mp;data=02%7C01%7C%7Cdf65836c80724301fcb708d6fa59d66a%7C84df9e7fe9f640
afb435aaaaaaaaaaaa%7C1%7C0%7C636971661089463959&amp;sdata=tCdDcf%2F6ME
1JKCH0qmq1pVpj99%2FwC2V5ki46P6Pasho%3D&amp;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@...]
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://eur01.safelinks.protection.outlook.com/?url=www.turner42.com&a
mp;data=02%7C01%7C%7Cdf65836c80724301fcb708d6fa59d66a%7C84df9e7fe9f640
afb435aaaaaaaaaaaa%7C1%7C0%7C636971661089463959&amp;sdata=tCdDcf%2F6ME
1JKCH0qmq1pVpj99%2FwC2V5ki46P6Pasho%3D&amp;reserved=0<https://eur01.sa
felinks.protection.outlook.com/?url=http%3A%2F%2Fwww.turner42.com&amp;
data=02%7C01%7C%7Cdf65836c80724301fcb708d6fa59d66a%7C84df9e7fe9f640afb
435aaaaaaaaaaaa%7C1%7C0%7C636971661089463959&amp;sdata=LE6c84CbTDjQLkm
haQkoDoE4xVd59Cn5DSI%2BZ1RVprY%3D&amp;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@...<mailto:cookcafe@...>> 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



















moderated Re: Excel Formula

Russell Solowoniuk
 

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@...> wrote:

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@...]
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&amp;data=02%7C01%7C%7C57cb9d9db0d04a5c3f6708d6fa57650d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971650591002154&amp;sdata=7i9qEP%2FCUNz71CxoI3cjdNbH5jXkDEIU4XETbocdmks%3D&amp;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@...]
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&amp;data=02%7C01%7C%7C57cb9d9db0d04a5c3f6708d6fa57650d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971650591002154&amp;sdata=7i9qEP%2FCUNz71CxoI3cjdNbH5jXkDEIU4XETbocdmks%3D&amp;reserved=0<https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.turner42.com&amp;data=02%7C01%7C%7C57cb9d9db0d04a5c3f6708d6fa57650d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971650591002154&amp;sdata=oO3mhEA78GdSJnFW5qzx%2BYYEqmYsU585yjesDnuvKWU%3D&amp;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@...<mailto:cookcafe@...>> 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



















moderated Re: Excel Formula

Richard Turner
 

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@...]
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&amp;data=02%7C01%7C%7C57cb9d9db0d04a5c3f6708d6fa57650d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971650591002154&amp;sdata=7i9qEP%2FCUNz71CxoI3cjdNbH5jXkDEIU4XETbocdmks%3D&amp;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@...]
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&amp;data=02%7C01%7C%7C57cb9d9db0d04a5c3f6708d6fa57650d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971650591002154&amp;sdata=7i9qEP%2FCUNz71CxoI3cjdNbH5jXkDEIU4XETbocdmks%3D&amp;reserved=0<https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.turner42.com&amp;data=02%7C01%7C%7C57cb9d9db0d04a5c3f6708d6fa57650d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971650591002154&amp;sdata=oO3mhEA78GdSJnFW5qzx%2BYYEqmYsU585yjesDnuvKWU%3D&amp;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@...<mailto:cookcafe@...>> 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

moderated Re: Excel Formula

Mario
 

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@...]
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@...]
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&amp;data=02%7C01%7C%7C0d3d893b497f40b286ef08d6fa52afb0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971630370466862&amp;sdata=t4P9ngoprfyq5VkbYdTfOzNj8%2FyhMepM2dlNI0nWQVQ%3D&amp;reserved=0<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.turner42.com&amp;data=02%7C01%7C%7C0d3d893b497f40b286ef08d6fa52afb0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971630370466862&amp;sdata=wSbsazxpgdNeSTKDzjt9QKMsjIz8fSIlQexyjLq%2BEcE%3D&amp;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@...<mailto:cookcafe@...>> 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

moderated Re: Excel Formula

Richard Turner
 

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@...]
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&amp;data=02%7C01%7C%7C0d3d893b497f40b286ef08d6fa52afb0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971630370466862&amp;sdata=t4P9ngoprfyq5VkbYdTfOzNj8%2FyhMepM2dlNI0nWQVQ%3D&amp;reserved=0<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.turner42.com&amp;data=02%7C01%7C%7C0d3d893b497f40b286ef08d6fa52afb0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636971630370466862&amp;sdata=wSbsazxpgdNeSTKDzjt9QKMsjIz8fSIlQexyjLq%2BEcE%3D&amp;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@...<mailto:cookcafe@...>> 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

moderated Re: Excel Formula

Mario
 

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@...]
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@...<mailto:cookcafe@...>> 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

moderated Re: Excel Formula

Russell Solowoniuk
 

Hi Richard,

I see no difference in my steps and yours? :)

Thanks,

Russell

On Jun 26, 2019, at 10:02 AM, Richard Turner <richardturner42@...> wrote:

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


On Jun 25, 2019, at 5:17 PM, Steve & Shannon Cook <cookcafe@...> 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
 
 


moderated Re: Excel Formula

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



On Jun 25, 2019, at 5:17 PM, Steve & Shannon Cook <cookcafe@...> 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

 

 

moderated Re: Excel Formula

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



On Jun 25, 2019, at 5:17 PM, Steve & Shannon Cook <cookcafe@...> 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

 

 



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 Gramm-Leach-Bliley 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


If you prefer not to receive future e-mail offers for products or services from Key
send an e-mail to mailto:DNERequests@... with 'No Promotional E-mails' in the SUBJECT line.

moderated Using Skype

Justin Mcdevitt
 

Hello List-members,

 

I have scheduled a training session (via Skype) with a BrailleNote user for tomorrow to provide some training in using the Apex which I recently purchased, primarily as a Notetaker. I am reaching out to the list to request some assistance with using Skype, a program that I haven’t used in a number of years.

I have set up a Skype account and downloaded the Windows 10 desktop version of Skype and reviewed the JAWS/Skype keyboard commands.   

What I would appreciate is the opportunity to review some of these commands and get some direction in adding a contact and setting up a Skype session to participate in this Apex training, again scheduled for tomorrow.

If anyone, who is familiar with Skype has some time today to provide some direction, I would appreciate it. Please contact me offlist: jhmcdev@....

 

Best, Justin .

 

moderated Re: Excel Formula

Russell Solowoniuk
 

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@...> 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