Hi all
I'm trying to do something that I'm starting to think can't be done.
I'm trying to filter Table1 by category and update the subtotals above. The subtotal for the specific filtered category works as it should using subtotal 109, however what I can't figure out is how to subtotal multiple categories regardless if any category is actually filtered. One note is my table is ever growing, so I wouldn't be able to lock in a specific range.
Thank you
I'm trying to do something that I'm starting to think can't be done.
I'm trying to filter Table1 by category and update the subtotals above. The subtotal for the specific filtered category works as it should using subtotal 109, however what I can't figure out is how to subtotal multiple categories regardless if any category is actually filtered. One note is my table is ever growing, so I wouldn't be able to lock in a specific range.
Thank you
QQQ (1) (version 1).xlsb | ||||
---|---|---|---|---|
A | B | |||
1 | Subtotal Red & Green | |||
2 | Filtered Subtotal | 51 | ||
3 | ||||
4 | Category | Amount | ||
5 | Green | 4 | ||
6 | Red | 6 | ||
7 | Blue | 5 | ||
8 | Green | 8 | ||
9 | Blue | 3 | ||
10 | Blue | 7 | ||
11 | Red | 9 | ||
12 | Green | 2 | ||
13 | Blue | 5 | ||
14 | Green | 2 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2 | B2 | =SUBTOTAL(109,Table1[Amount]) |