I've got a 50,000-row Excel database with various controls that hide rows
for various reasons. Now I want to summarize the non-hidden rows in various
ways. Unfortunately, SUBTOTAL, DSUM, and similar functions rely directly or
indirectly on a Criteria range.

Logically, I have two choices. I could write custom SUM, COUNT, and other
such functions, which would apply only to the unhidden rows. Alternatively,
I could mark each row somehow so that a simple Criteria could recognize the
unhidden rows, filter the data, and allow me to use SUBTOTAL, DSUM, and the
like.

Any of these alternatives would be possible, of course. But they all require
many seconds to perform. This creates a very sluggish user interface.

Can anyone suggest a speedy way to transform a database with hidden rows
into a filtered database with the same rows hidden?

Thanks.

Charley