Hidden Cells
 

How do you total the number of cells in a column without includnig the hidden
cells in the same column?

If the cells are hidden as a result of filtering, you could use something
like:

=SUBTOTAL(9,A2:A8)

If you have manually hidden the rows, I don't know how you achieve what you
want

Regards

Trevor


"Helpme" wrote in message
...
How do you total the number of cells in a column without includnig the
hidden
cells in the same column?

Trevor and Helpme.

If rows are manually hidden, upgrade to Excel 2003 which has an added SUBTOTAL
Function for this.

e.g. =SUBTOTAL(109,A1:A100) ignores cells in hidden rows.

The SUBTOTAL(9, range) still works for filtered rows.


Gord Dibben Excel MVP



On Fri, 11 Mar 2005 21:17:50 -0000, "Trevor Shuttleworth"
wrote:

If the cells are hidden as a result of filtering, you could use something
like:

=SUBTOTAL(9,A2:A8)

If you have manually hidden the rows, I don't know how you achieve what you
want

Regards

Trevor


"Helpme" wrote in message
...
How do you total the number of cells in a column without includnig the
hidden
cells in the same column?

Gord

thanks for this advice. I'm using Excel 2003 ... I just didn't know about
this option. So much to learn, so little time !

Thanks

Trevor


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Trevor and Helpme.

If rows are manually hidden, upgrade to Excel 2003 which has an added
SUBTOTAL
Function for this.

e.g. =SUBTOTAL(109,A1:A100) ignores cells in hidden rows.

The SUBTOTAL(9, range) still works for filtered rows.


Gord Dibben Excel MVP



On Fri, 11 Mar 2005 21:17:50 -0000, "Trevor Shuttleworth"
wrote:

If the cells are hidden as a result of filtering, you could use something
like:

=SUBTOTAL(9,A2:A8)

If you have manually hidden the rows, I don't know how you achieve what
you
want

Regards

Trevor


"Helpme" wrote in message
...
How do you total the number of cells in a column without includnig the
hidden
cells in the same column?