Returns sum of certain column in range (or table) in sheet after applying AutoFilter
It reset Autofilter, applies up to 3 filters, gets total (sum) then remove Autofilter from certain sheet, giving 1st top left cell (header cell).
This method is way faster than creating loop into those rows to check for the same condition.
Finally, a fine way to quickly filter data in sheet
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydev.net
Linkedin Login
Sum1stCell, Filter1stCell, FilterSheet, Optional FilterWB = "This", Optional Filter1Column = 0, Optional Filter1List = "", Optional Filter2Column = 0, Optional Filter2List = "", Optional Filter3Column = 0, Optional Filter3List = ""
Views 892
Downloads 295
CodeID
DB ID
