I have this formula:

=INDIRECT("PrintData!J" &RowIndex)

and need to wrap a subtotal 9, around it so that it only includes
visible rows when there is an auto filter applied on the PrintData
page

Any possible solutions to add?

thanks

chris

Try this,

=Subtotal(9,Indirect("PrintData!"&"J2:J20"))

Adjust range J2:J20 to your suit.

"Chris" wrote in message
...
I have this formula:

=INDIRECT("PrintData!J" &RowIndex)

and need to wrap a subtotal 9, around it so that it only includes
visible rows when there is an auto filter applied on the PrintData
page

Any possible solutions to add?

thanks

chris