PDA

View Full Version : Solved: Counting rows?



Alasbabylon
07-29-2009, 06:54 AM
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
07-29-2009, 07:01 AM
With or without VBA?

Alasbabylon
07-29-2009, 07:11 AM
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
07-29-2009, 07:23 AM
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
07-29-2009, 08:35 AM
AWESOME! Thanks so much! It works like a Charm!