ok when I press controll 1 i get
formate cells number page number tab , come up or that is what jaws
says!! and I cant work out what to do next.
I did the =b2 thing as well and that seems to be working fine.
cheers Joe
-----Original Message-----
From: Nicole Massey
Sent: Thursday, September 25, 2014 6:12 PM
To: [email protected] ; 'The Jaws for Windows support list.'
Subject: RE: excel
Try this as a troubleshooting trick. In another cell, type a direct
reference to any cell that contains a number. So, for instance, if there's
data in B2 then type into this other cell =B2 and hit enter. Now go back to
that cell, and if the value is there, it's something else. However, if the
value in that cell is =B2 then hold down your control key and hit the grave
key to the left of the one, because you've gotten yourself into formula view
mode. This should switch you back.
Another possible problem is the type of data the cell expects. Hold down the
control key and press 1. This should get you into the cell format window.
Make sure you're on the cell type page and select Number and the number of
decimal places you want. (Probably 0) You can hit enter in any part of this
screen to return to your worksheet.
-----Original Message-----
From: Jfw [mailto:[email protected]] On Behalf Of
stintonjoe--- via Jfw
Sent: Thursday, September 25, 2014 12:09 PM
To: jaws users
Subject: Re: excel
ok still not getting this the formula i have tryed is =COUNTIF(b2: b
420,50 but all that is showing up in the cel is what i have put in as
a
formaler so jaws will say =COUNTIF(b2: b 420,50 b 427 and not the
answer.
I hope I am makeing some sort of sence thanks Joe
-----Original Message-----
From: Nicole Massey
Sent: Thursday, September 25, 2014 4:14 PM
To: [email protected] ; 'The Jaws for Windows support list.'
Subject: RE: excel
As mentioned by others, the countif command is yourfriend in this. The
format is =COUNTIF(first cell in the range:last cell in the range,
value you want to count) The value can be a number, text in quotes, or
the contents of another cell.
Note that if you try to count in adjacent columns you can count them
all in one operation by setting the value after the colon to the last
cell in the second column. (or third, forth, etc.)
> -----Original Message-----
> From: Jfw [mailto:[email protected]]
> On Behalf Of stintonjoe--- via Jfw
> Sent: Thursday, September 25, 2014 3:06 AM
> To: jaws users
> Subject: excel
>
> Hi all
>
> I have a sheet in excel and I want to do a formula which will
first
> look at a collem and count how many times the number 50 turnse up
then
> I want to do the same formaler for another collem then I want
> another cell which adds the to together .
> so how can this be done?
> I have windows 7 and jaws 12
>
> thanks in advance Joe
> -------------- next part -------------- An HTML attachment was
> scrubbed...
> URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-
> jdh.com/attachments/20140925/80659d3b/attachment.html>
> _______________________________________________
> Jfw mailing list
> [email protected]
> http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com
_______________________________________________
Jfw mailing list
[email protected]
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com
_______________________________________________
Jfw mailing list
[email protected]
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com
