counting rows across multiple worksheets

[Aleks]

I am trying to count and add all rows populated with values across multiple
worksheets. Is there an easy way to do this?

[RagDyer]

The *easiest* way is to perform the count and/or the totaling on each
individual sheet in the *same* relative cell.
So, say the count is displayed in X100 on *all* sheets,
And the sum is displayed in X101 on *all* sheets.

On the main sheet, use formulas similar to these:

=SUM(Sheet1:Sheet5!X100)
=SUM(Sheet1:Sheet5!X101)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Aleks" <[email protected]> wrote in message
news:[email protected]...
> I am trying to count and add all rows populated with values across
multiple
> worksheets. Is there an easy way to do this?