Subtotal Function
 

I understand the €œSubtotal€� function only ignores hidden data in rows. Is
there a similar function that will ignore hidden data in columns? Thanks.

Subtotal Function
 

Hi

No built in function but look at the workaround produced by Debar
Dalgleish
http://www.contextures.com/HideMarkedCols.zip

--
Regards

Roger Govier


"lindsayhyle" wrote in message
...
I understand the "Subtotal" function only ignores hidden data in rows.
Is
there a similar function that will ignore hidden data in columns?
Thanks.

Subtotal Function
 

produced by Debar Dalgleish

Or even Debra Dalgleish.
Sorry Deb, it's late and last night was an all-nighter. Well that's my
excuse anyway<g
I even got Dalgleish as Dalgelish this time till spell checker picked it
up.
Definitely time for bed.


--
Regards

Roger Govier


"Roger Govier" wrote in message
...
Hi

No built in function but look at the workaround produced by Debar
Dalgleish
http://www.contextures.com/HideMarkedCols.zip

--
Regards

Roger Govier


"lindsayhyle" wrote in message
...
I understand the "Subtotal" function only ignores hidden data in rows.
Is
there a similar function that will ignore hidden data in columns?
Thanks.

Subtotal Function
 

Thanks! I will give that a try.

"Roger Govier" wrote:


produced by Debar Dalgleish

Or even Debra Dalgleish.
Sorry Deb, it's late and last night was an all-nighter. Well that's my
excuse anyway<g
I even got Dalgleish as Dalgelish this time till spell checker picked it
up.
Definitely time for bed.


--
Regards

Roger Govier


"Roger Govier" wrote in message
...
Hi

No built in function but look at the workaround produced by Debar
Dalgleish
http://www.contextures.com/HideMarkedCols.zip

--
Regards

Roger Govier


"lindsayhyle" wrote in message
...
I understand the "Subtotal" function only ignores hidden data in rows.
Is
there a similar function that will ignore hidden data in columns?
Thanks.