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



My Own Work

Sum1stCell, Filter1stCell, FilterSheet, Optional FilterWB = "This", Optional Filter1Column = 0, Optional Filter1List = "", Optional Filter2Column = 0, Optional Filter2List = "", Optional Filter3Column = 0, Optional Filter3List = ""

Views 734 Downloads 207