Is there a tutorial or something that goes over all of the various formulas for Excel? I need to refresh my memory on this stuff. I'm working on using a tracking system, and wanted to use a spreadsheet to do most of it for me.
-----Original Message----- From: Jfw [mailto:[email protected]] On Behalf Of Nicole Massey via Jfw Sent: Thursday, September 25, 2014 10:15 AM 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
