| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
counting rows across multiple worksheets
I am trying to count and add all rows populated with values across multiple
worksheets. Is there an easy way to do this? |
|
#2
|
|||
|
|||
|
counting rows across multiple worksheets
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" wrote in message ... I am trying to count and add all rows populated with values across multiple worksheets. Is there an easy way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate rows across multiple worksheets | Excel Discussion (Misc queries) | |||
| Sort rows across multiple worksheets - Excel 2003 | Excel Worksheet Functions | |||
| Deleting multiple rows through a formula | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| Inserting Multiple Rows with Formulas | Excel Worksheet Functions | |||
Hybrid Mode
