counting rows across multiple worksheets

G

Guest

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

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!
==============================================
 

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

counting text same cell multiple worksheets 11
how do i combine excel worksheets 1
How do I count unique email addresses across multiple worksheets? 2
Counting values in mulitple worksheets 2
Copying multiple rows to other worksheets (but amount of rows varies) - How? 1
renumbering rows 4
Need to merge worksheets - Excel 2003 0
Ranking across worksheets 3

Top