Make sure all the numerals in the columns are in fact in number format. If 50 has somehow been entered but is put in as text, it will not be counted in a formula. Not sure if the COUNTIF function will accept text versions of numbers.
-----Original Message----- From: Jfw [mailto:[email protected]] On Behalf Of stintonjoe--- via Jfw Sent: Thursday, September 25, 2014 2: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
