Solved: Counting rows?

[Alasbabylon]

Help! I've just converted over to Office 2007 and am mired in ribbons, searching for things, and saying bad words under my breath. I need to know if there is a way to get a count of the number of rows in all the workseehts in a file. I have a spreadsheet with 11 sheets, they have anywhere from 25 to 63,345 rows each. I wanted to have a summary sheet that shows the name of each sheet and how many rows are on that sheet. How?

[Bob Phillips]

With or without VBA?

[Alasbabylon]

Without, preferably. What I'd really like is to be able to have a column for worksheet name followed by a column for number of rows. If VBA is the best way to go, I can do that, with some heavy duty hand holding - I'm a VBA Dummy to the nth degree.

[Bob Phillips]

If you have a key column in each sheet, say A, you can simply use

=COUNTIF(Sheet2!A:A<,"<>")

If the rows might have embedded blanks and you nee to count them, you could use

=MAX(IF(Sheet2!A1:A63345<>"",row(A1:A63345))

as an array formula and so on

[Alasbabylon]

AWESOME! Thanks so much! It works like a Charm!