Thank you for this great plugin!
Is there a way to display the sum of all values in a column that automatically adjusts after filtering?
Right now, I am using the =SUM(B2:B50)formula for column B in the footer, but that formula has to be manually updated when more rows are added and (of course) it still displays the sum of all 50 values after a filtering when fewer rows are displayed.
Example: column B is an expense column for different projects. If there are 20 rows with a particular project name, I need to have the sum of those 20 column B cells only, not all 50.
Thank you for your help!
- The topic ‘autosum column values with filtering’ is closed to new replies.