Yes, I've done this before with putting a 1 or a 0 in the cell so that I could count how many rows met a certain criteria. So for example, if I want to keep track of how many people had paid their dues, in the Paid column I would enter a 1 if they paid, or a 0 if they had not. Then I would have a total cell at the bottom of the column. Another way to do this is with the Count function. This is helpful when you have more then 2 criteria. An example would be keeping track of how many people paid via cash, check, credit card, and those who had not yet paid. You assign a value to each of these criteria, i.e. 0=not yet paid, 1=cash, 2= check and 3=credit card. You then set up a cell for each criteria that you want to get a total on using the Count function. So you would have 4 cells set up, 1 to count the total number of cash payments, 1 for counting total number of check payments, etc.
Unfortunately, I can't tell you off of the top of my head how to set up the count function. Over the next few days, I will try and find a spreadsheet where I set this up and see if I can provide you with more info. Maybe someone else on this list can help sooner. You might want to post this question to the Blind Computing list as this is more of an application question then a JAWS question. HTH, Annette -----Original Message----- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Bill Tipton Sent: Thursday, February 12, 2009 10:00 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] Excel - fill column with 1's Hi all, How can I fill a column in a Excel 2003 spreadsheet range with 1's? For example f3-f420. I want to have a column where I can easily add up the number of rows with data. Then I can use that total for other calculations. I am using Jaws 9. Thank you, Bill Bill Tipton http://globaldialoguecenter.blogs.com/disabilities/ Visit the JAWS Users List home page at: http://www.jaws-users.com Visit the Blind Computing home page at: http://www.blind-computing.com Address for the list archives: http://www.mail-archive.com/jaws-users-list@jaws-users.com To post to this group, send email to jaws-users-list@jaws-users.com To unsubscribe from this group, send an email to jaws-users-list-le...@jaws-users.com For help from Mailman with your account Put the word help in the subject or body of a blank message to: jaws-users-list-requ...@jaws-users.com Use the following address in order to contact the management team jaws-users-list-ow...@jaws-users.com If you wish to join the Blind Computing list send a blank email to the following address: blind-computing-j...@jaws-users.com Visit the JAWS Users List home page at: http://www.jaws-users.com Visit the Blind Computing home page at: http://www.blind-computing.com Address for the list archives: http://www.mail-archive.com/jaws-users-list@jaws-users.com To post to this group, send email to jaws-users-list@jaws-users.com To unsubscribe from this group, send an email to jaws-users-list-le...@jaws-users.com For help from Mailman with your account Put the word help in the subject or body of a blank message to: jaws-users-list-requ...@jaws-users.com Use the following address in order to contact the management team jaws-users-list-ow...@jaws-users.com If you wish to join the Blind Computing list send a blank email to the following address: blind-computing-j...@jaws-users.com
