Hi All

I have a sheet with hundreds of lines of data.
With this sheet I use auto-filter and Subtotal which will show only
totals of the visable lines.

Is it possible to use Sumproduct in the same manor?


Thanks for your help


Tom Snyder


x-- 100 Proof News - http://www.100ProofNews.com
x-- 3,500+ Binary NewsGroups, and over 90,000 other groups
x-- Access to over 1 Terabyte per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD

One way

http://tinyurl.com/5skck


Regards,

Peo Sjoblom


"lehigh46" wrote in message
...
Hi All

I have a sheet with hundreds of lines of data.
With this sheet I use auto-filter and Subtotal which will show only
totals of the visable lines.

Is it possible to use Sumproduct in the same manor?


Thanks for your help


Tom Snyder


x-- 100 Proof News - http://www.100ProofNews.com
x-- 3,500+ Binary NewsGroups, and over 90,000 other groups
x-- Access to over 1 Terabyte per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD