excel


Dave...
 

Tom,

Yes, that looks like the right syntax with punctuations.

Dave Carlson
Tastefully composed and transmitted from somewhere in the Western United
States, using a Dell Latitude E6520 and Windows 7

----- Original Message -----
From: "Bissett, Tom" <tom.bissett@bmo.com>
To: "The Jaws for Windows support list." <jfw@lists.the-jdh.com>
Sent: Thursday, March 15, 2012 12:31
Subject: RE: excel


Your function should look like this
=COUNTIF(A2:A5,"=50")
This should give you what you need. You just need to set the range to what
you need.

Tom Bisset
-----Original Message-----
From: jfw-bounces@lists.the-jdh.com [mailto:jfw-bounces@lists.the-jdh.com]
On Behalf Of joe@stintononline.demon.co.uk
Sent: March 15, 2012 3:15 PM
To: The Jaws for Windows support list.
Subject: Re: excel

hi again

ok found the count if function but cant work it out I'm trying countif b2
b250 =50
I have tried typing this in lots of different ways but with no luck.

thanks once again and sorry for being such a numpty Joe

-----Original Message-----
From: Charles Coe
Sent: Thursday, March 15, 2012 6:57 PM
To: 'The Jaws for Windows support list.'
Subject: RE: excel

The countif can be found under the formula tab under the sub title "function
library".


-----Original Message-----
From: jfw-bounces@lists.the-jdh.com [mailto:jfw-bounces@lists.the-jdh.com]
On Behalf Of joe@stintononline.demon.co.uk
Sent: Thursday, March 15, 2012 11:37 AM
To: The Jaws for Windows support list.
Subject: Re: excel

hi
I have been looking for the count if function but i cant find it could you
please give us a clue where it is.

cheers Joe

-----Original Message-----
From: Farfar Getting Around
Sent: Thursday, March 15, 2012 3:54 PM
To: The Jaws for Windows support list.
Subject: Re: excel

Yes, look at the COUNTIF function. You should be able to put in a test value
for a range of cells and count those that match.

Dave Carlson
Tastefully composed and transmitted from somewhere in the Western United
States, using a Dell Latitude E6520 and Windows 7


----- Original Message -----
From: <joe@stintononline.demon.co.uk>
To: "jaws users" <jfw@lists.the-jdh.com>
Sent: Thursday, March 15, 2012 07:56
Subject: excel


hi all

wandering if any one can tell me how or even if i can make micro soft excel
look at a collem of numbers count how many of them equal 50 and tell me in
another cell.

well if any one can help I would be great full cheers Joe
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/201203
15/664a9957/attachment.html>
_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com



_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com



_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com

_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


Dave...
 

Joe,

Sounds like you have punctuation turned off because you're missing colons,
commas, parentheses, and quote marks.


Dave Carlson
Tastefully composed and transmitted from somewhere in the Western United
States, using a Dell Latitude E6520 and Windows 7

----- Original Message -----
From: <joe@stintononline.demon.co.uk>
To: "The Jaws for Windows support list." <jfw@lists.the-jdh.com>
Sent: Thursday, March 15, 2012 12:14
Subject: Re: excel


hi again

ok found the count if function but cant work it out I'm trying countif b2
b250 =50
I have tried typing this in lots of different ways but with no luck.

thanks once again and sorry for being such a numpty Joe

-----Original Message-----
From: Charles Coe
Sent: Thursday, March 15, 2012 6:57 PM
To: 'The Jaws for Windows support list.'
Subject: RE: excel

The countif can be found under the formula tab under the sub title "function
library".


-----Original Message-----
From: jfw-bounces@lists.the-jdh.com [mailto:jfw-bounces@lists.the-jdh.com]
On Behalf Of joe@stintononline.demon.co.uk
Sent: Thursday, March 15, 2012 11:37 AM
To: The Jaws for Windows support list.
Subject: Re: excel

hi
I have been looking for the count if function but i cant find it could you
please give us a clue where it is.

cheers Joe

-----Original Message-----
From: Farfar Getting Around
Sent: Thursday, March 15, 2012 3:54 PM
To: The Jaws for Windows support list.
Subject: Re: excel

Yes, look at the COUNTIF function. You should be able to put in a test value
for a range of cells and count those that match.

Dave Carlson
Tastefully composed and transmitted from somewhere in the Western United
States, using a Dell Latitude E6520 and Windows 7


----- Original Message -----
From: <joe@stintononline.demon.co.uk>
To: "jaws users" <jfw@lists.the-jdh.com>
Sent: Thursday, March 15, 2012 07:56
Subject: excel


hi all

wandering if any one can tell me how or even if i can make micro soft excel
look at a collem of numbers count how many of them equal 50 and tell me in
another cell.

well if any one can help I would be great full cheers Joe
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/201203
15/664a9957/attachment.html>
_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com



_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com



_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


Bissett, Tom <tom.bissett@...>
 

Your function should look like this
=COUNTIF(A2:A5,"=50")
This should give you what you need. You just need to set the range to what you need.

Tom Bisset

-----Original Message-----
From: jfw-bounces@lists.the-jdh.com [mailto:jfw-bounces@lists.the-jdh.com] On Behalf Of joe@stintononline.demon.co.uk
Sent: March 15, 2012 3:15 PM
To: The Jaws for Windows support list.
Subject: Re: excel

hi again

ok found the count if function but cant work it out I'm trying countif b2
b250 =50
I have tried typing this in lots of different ways but with no luck.

thanks once again and sorry for being such a numpty Joe

-----Original Message-----
From: Charles Coe
Sent: Thursday, March 15, 2012 6:57 PM
To: 'The Jaws for Windows support list.'
Subject: RE: excel

The countif can be found under the formula tab under the sub title "function
library".


-----Original Message-----
From: jfw-bounces@lists.the-jdh.com [mailto:jfw-bounces@lists.the-jdh.com]
On Behalf Of joe@stintononline.demon.co.uk
Sent: Thursday, March 15, 2012 11:37 AM
To: The Jaws for Windows support list.
Subject: Re: excel

hi
I have been looking for the count if function but i cant find it could you
please give us a clue where it is.

cheers Joe

-----Original Message-----
From: Farfar Getting Around
Sent: Thursday, March 15, 2012 3:54 PM
To: The Jaws for Windows support list.
Subject: Re: excel

Yes, look at the COUNTIF function. You should be able to put in a test value
for a range of cells and count those that match.

Dave Carlson
Tastefully composed and transmitted from somewhere in the Western United
States, using a Dell Latitude E6520 and Windows 7


----- Original Message -----
From: <joe@stintononline.demon.co.uk>
To: "jaws users" <jfw@lists.the-jdh.com>
Sent: Thursday, March 15, 2012 07:56
Subject: excel


hi all

wandering if any one can tell me how or even if i can make micro soft excel
look at a collem of numbers count how many of them equal 50 and tell me in
another cell.

well if any one can help I would be great full cheers Joe
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/201203
15/664a9957/attachment.html>
_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com



_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com



_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


joe stinton
 

hi again

ok found the count if function but cant work it out I'm trying countif b2 b250 =50
I have tried typing this in lots of different ways but with no luck.

thanks once again and sorry for being such a numpty Joe

-----Original Message-----
From: Charles Coe
Sent: Thursday, March 15, 2012 6:57 PM
To: 'The Jaws for Windows support list.'
Subject: RE: excel

The countif can be found under the formula tab under the sub title "function
library".


-----Original Message-----
From: jfw-bounces@lists.the-jdh.com [mailto:jfw-bounces@lists.the-jdh.com]
On Behalf Of joe@stintononline.demon.co.uk
Sent: Thursday, March 15, 2012 11:37 AM
To: The Jaws for Windows support list.
Subject: Re: excel

hi
I have been looking for the count if function but i cant find it could you
please give us a clue where it is.

cheers Joe

-----Original Message-----
From: Farfar Getting Around
Sent: Thursday, March 15, 2012 3:54 PM
To: The Jaws for Windows support list.
Subject: Re: excel

Yes, look at the COUNTIF function. You should be able to put in a test value
for a range of cells and count those that match.

Dave Carlson
Tastefully composed and transmitted from somewhere in the Western United
States, using a Dell Latitude E6520 and Windows 7


----- Original Message -----
From: <joe@stintononline.demon.co.uk>
To: "jaws users" <jfw@lists.the-jdh.com>
Sent: Thursday, March 15, 2012 07:56
Subject: excel


hi all

wandering if any one can tell me how or even if i can make micro soft excel
look at a collem of numbers count how many of them equal 50 and tell me in
another cell.

well if any one can help I would be great full cheers Joe
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/201203
15/664a9957/attachment.html>
_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com



_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


Charles Coe
 

The countif can be found under the formula tab under the sub title "function
library".

-----Original Message-----
From: jfw-bounces@lists.the-jdh.com [mailto:jfw-bounces@lists.the-jdh.com]
On Behalf Of joe@stintononline.demon.co.uk
Sent: Thursday, March 15, 2012 11:37 AM
To: The Jaws for Windows support list.
Subject: Re: excel

hi
I have been looking for the count if function but i cant find it could you
please give us a clue where it is.

cheers Joe

-----Original Message-----
From: Farfar Getting Around
Sent: Thursday, March 15, 2012 3:54 PM
To: The Jaws for Windows support list.
Subject: Re: excel

Yes, look at the COUNTIF function. You should be able to put in a test value
for a range of cells and count those that match.

Dave Carlson
Tastefully composed and transmitted from somewhere in the Western United
States, using a Dell Latitude E6520 and Windows 7


----- Original Message -----
From: <joe@stintononline.demon.co.uk>
To: "jaws users" <jfw@lists.the-jdh.com>
Sent: Thursday, March 15, 2012 07:56
Subject: excel


hi all

wandering if any one can tell me how or even if i can make micro soft excel
look at a collem of numbers count how many of them equal 50 and tell me in
another cell.

well if any one can help I would be great full cheers Joe
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/201203
15/664a9957/attachment.html>
_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com



_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


Dave...
 

Formula Tab, Function Library, type in Countif as a single word.


Dave Carlson
Tastefully composed and transmitted from somewhere in the Western United
States, using a Dell Latitude E6520 and Windows 7

----- Original Message -----
From: <joe@stintononline.demon.co.uk>
To: "The Jaws for Windows support list." <jfw@lists.the-jdh.com>
Sent: Thursday, March 15, 2012 11:36
Subject: Re: excel


hi
I have been looking for the count if function but i cant find it could you
please give us a clue where it is.

cheers Joe

-----Original Message-----
From: Farfar Getting Around
Sent: Thursday, March 15, 2012 3:54 PM
To: The Jaws for Windows support list.
Subject: Re: excel

Yes, look at the COUNTIF function. You should be able to put in a test value
for a range of cells and count those that match.

Dave Carlson
Tastefully composed and transmitted from somewhere in the Western United
States, using a Dell Latitude E6520 and Windows 7


----- Original Message -----
From: <joe@stintononline.demon.co.uk>
To: "jaws users" <jfw@lists.the-jdh.com>
Sent: Thursday, March 15, 2012 07:56
Subject: excel


hi all

wandering if any one can tell me how or even if i can make micro soft excel
look at a collem of numbers count how many of them equal 50 and tell me in
another cell.

well if any one can help I would be great full cheers Joe
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20120315/664a9957/attachment.html>
_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com



_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


joe stinton
 

hi again

I have been looking for the countif function but I cant find it so could you please tell me were it is.

thanks once again and sorry for being such a numpty Joe

-----Original Message-----
From: Farfar Getting Around
Sent: Thursday, March 15, 2012 3:54 PM
To: The Jaws for Windows support list.
Subject: Re: excel

Yes, look at the COUNTIF function. You should be able to put in a test value
for a range of cells and count those that match.

Dave Carlson
Tastefully composed and transmitted from somewhere in the Western United
States, using a Dell Latitude E6520 and Windows 7


----- Original Message -----
From: <joe@stintononline.demon.co.uk>
To: "jaws users" <jfw@lists.the-jdh.com>
Sent: Thursday, March 15, 2012 07:56
Subject: excel


hi all

wandering if any one can tell me how or even if i can make micro soft excel
look at a collem of numbers count how many of them equal 50 and tell me in
another cell.

well if any one can help I would be great full cheers Joe
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20120315/664a9957/attachment.html>
_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


joe stinton
 

hi
I have been looking for the count if function but i cant find it could you please give us a clue where it is.

cheers Joe

-----Original Message-----
From: Farfar Getting Around
Sent: Thursday, March 15, 2012 3:54 PM
To: The Jaws for Windows support list.
Subject: Re: excel

Yes, look at the COUNTIF function. You should be able to put in a test value
for a range of cells and count those that match.

Dave Carlson
Tastefully composed and transmitted from somewhere in the Western United
States, using a Dell Latitude E6520 and Windows 7


----- Original Message -----
From: <joe@stintononline.demon.co.uk>
To: "jaws users" <jfw@lists.the-jdh.com>
Sent: Thursday, March 15, 2012 07:56
Subject: excel


hi all

wandering if any one can tell me how or even if i can make micro soft excel
look at a collem of numbers count how many of them equal 50 and tell me in
another cell.

well if any one can help I would be great full cheers Joe
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20120315/664a9957/attachment.html>
_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


Dave...
 

Yes, look at the COUNTIF function. You should be able to put in a test value
for a range of cells and count those that match.

Dave Carlson
Tastefully composed and transmitted from somewhere in the Western United
States, using a Dell Latitude E6520 and Windows 7

----- Original Message -----
From: <joe@stintononline.demon.co.uk>
To: "jaws users" <jfw@lists.the-jdh.com>
Sent: Thursday, March 15, 2012 07:56
Subject: excel


hi all

wandering if any one can tell me how or even if i can make micro soft excel
look at a collem of numbers count how many of them equal 50 and tell me in
another cell.

well if any one can help I would be great full cheers Joe
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20120315/664a9957/attachment.html>
_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


joe stinton
 

hi all

wandering if any one can tell me how or even if i can make micro soft excel look at a collem of numbers count how many of them equal 50 and tell me in another cell.

well if any one can help I would be great full cheers Joe
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20120315/664a9957/attachment.html>