SUMPRODUCT
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 |
All times are GMT +1. The time now is 12:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com