Hello,
The below command works fine for a non-filtered data set. Is there an option to calculate result of a data set which is filtered
ThanksPlease Login or Register to view this content.
Hello,
The below command works fine for a non-filtered data set. Is there an option to calculate result of a data set which is filtered
ThanksPlease Login or Register to view this content.
Sure
1) add in all the conditions that you use for filtering
2) use a sumproduct that incorporates SUBTOTAL to only operate on visible cells
3) add a column of SUBTOTAL functions that will return 1 if they are visible, and add that condition to the countifs
Note that you don't need to build a string and use evaluate to take advantage of countifs - Application.Worksheetfunction.Countifs is available for use within VBA
Last edited by Bernie Deitrick; 02-12-2014 at 03:12 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks