Forum Discussion
Solved
Subtotal function with Text Criterias
I am trying to do a subtotal of the number with multiple criteria. E.g. with the sample data below, there will be filters applied to the table, say date filters. I am looking for the Subtotal of...
If so you need to add the helper column to the table like
=AGGREGATE(3,5,[@Color])which indicates if current row is filtered or not.
With that formula in L2 is
=SUMIFS(Table1[[Number]:[Number]], Table1[[Fruit]:[Fruit]],L$1, Table1[[Helper]:[Helper]],1)and drag it to the right.
If exclude Fruit filter the rest sum could be received by reference on table total
SergeiBaklan huge thanks! I've been looking for this exact solution. Have a merry Christmas and new year.
Thank you and Happy Holidays!