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.
 
Back
Top