ExcelBanter - Calculations on Only Unhidden Data Cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Calculations on Only Unhidden Data Cells (https://www.excelbanter.com/excel-discussion-misc-queries/48280-calculations-only-unhidden-data-cells.html)

dcotejr

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

Myrna Larson

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

All times are GMT +1. The time now is 02:22 AM.