Re: Determining how many rows have data in Excel 2003
- From: "Charles" <onthego2005@xxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Fri, 25 Jul 2008 21:53:46 -0700
Hi,
You can use the COUNTIF function to determine how many rows/cells have data
in them. for example:
=COUNTIF(D1:D20,">=0") will count the number of data filled cells within a
given range. This example will not count those cells with 0 or are blank.
The IF function can be found under Insert of the dialogue menu.
Charles
----- Original Message -----
From: "Bill Tipton" <bill.tipton@xxxxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Friday, July 25, 2008 6:55 PM
Subject: Determining how many rows have data in Excel 2003
Is there a way to jump to the end of data within a Excel spreadsheet?
I want a quick way to determine how many rows have data in them within
that particular sheet.
I am using Jaws 9 and Excel 2003.
Thank you.
Bill
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
If you have any concerns about the list, post received from the list, or
the way the list is being run, do not post them to the list. Rather
contact the list owner at jfw-admins@xxxxxxxxxxxxxx
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
Other related posts:
