LinkBack URL
About LinkBacks
I think just subtotal function can do the trick. At the top you put =subtotal(9,A2:A5000) if you have data from row 2 to 5000.
When you filter the data, the subtotal value will change, based on your filter criteria.
I think just subtotal function can do the trick. At the top you put =subtotal(9,A2:A5000) if you have data from row 2 to 5000.
When you filter the data, the subtotal value will change, based on your filter criteria.
Last edited by alexwangsa; 04-27-2007 at 12:09 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks