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...
=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.
Thanks so much!