How do I count the number of rows in a table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

It's simple: How do I write a formula which will give me the TOTAL NUMBER OF
ROWS in any given spreadsheet? Why should this prove so difficult? Why
wouldn't ROWS be the proper function? Why am I so stupid (or is it Excel
that's stupid)? HELP!
 
sirarthur8 said:
It's simple: How do I write a formula which will give me the TOTAL NUMBER OF
ROWS in any given spreadsheet? Why should this prove so difficult? Why
wouldn't ROWS be the proper function? Why am I so stupid (or is it Excel
that's stupid)? HELP!
Click to expand...

So is this an Excel question or an Access question? In Acess, if it's
an attached table, it's easy. You just create a count on some field in
the spreadsheet. In Excel you just use the Count function.
=Count(RangeName)

In Access, use a summary query and do pretty much the same thing.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - counting cells by colors and names to it in two different rows. 0
Excel Help to copy information from one row at a time to another sheet 1
count the number of rows in a query. 2
Function in Excel to count and list number of entries of text valuesin a row. 2
Count number of text rows??? 3
Excel Count of Consecutive Data 0
Counting records in a table 5
count data of multiple rows independently 0

Back
Top