Forum Discussion
Filter total
I have a table with data and days of the week with numbers in it. I want to filter the data and have the total summed for a single day instead of me having to highlight it and enter the data.
(So if I filter to show only data #2 I want the total for Mon, Tues, etc to show at the bottom)
I would format the data as a table: Home->Styles->Format as Table
Then click within the table, go to the "Table Design" tab, and check the "Total row" option
After that, you can set Totals for each column, which will be recalculated every time you apply filters to any column=BYCOL(B2:G9,LAMBDA(c,SUMIFS(c,A2:A9,J2)))
With Office 365 or Excel for the web you can apply this formula. The filter criteria is in cell J2 and the formula dynamically updates the results.
- The only thing I can't figure out is that one cell is not adding up correctly to what is actually in the column of one of the filters. It has the total as 3210 when the total in the column is 4545. My formula is correct and it is adding correctly in every other cell is right but just this one will not properly sum up the filter
Can you attach a screenshot of your sheet without sensitive data which shows all the data just like my screenshot does?
- Thanks so much!
