I have formulas that SUMIFS week numbers and currently only works when one week is selected. I need to use a formula to get the entire list of weeks that are in the filtered pivot table to be able to sum all of the weeks when a user selects multiple weeks. Any way to do this in a formula?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Get the filtered items in a pivot table
- Thread starter PCRIDE
- Start date
Similar threads
- Question
