| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Calculations on Only Unhidden Data Cells
I am trying to determine the best way to perform calculations (summation, average, etc.) on cells that are unhidden in a spreadsheet. After hiding the unused cells, what is the best way to accomplish this? Copy and Paste Special? Or is there some easier method? Thanks in advance! dcotejr -- dcotejr |
|
#2
|
|||
|
|||
|
Check out the SUBTOTAL function in Help.
On Tue, 19 Jul 2005 13:07:02 +0000, dcotejr wrote: I am trying to determine the best way to perform calculations (summation, average, etc.) on cells that are unhidden in a spreadsheet. After hiding the unused cells, what is the best way to accomplish this? Copy and Paste Special? Or is there some easier method? Thanks in advance! dcotejr |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to alter data on HTML webpage into Excell cells as numbers? | New Users to Excel | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Removing blank rows in a worksheet | Excel Worksheet Functions | |||
| How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
| How do I copy data (word) into respective cells when the data bei. | New Users to Excel | |||
Hybrid Mode
