Forum Discussion
Summing filtered cells and preserving the answer when filter is turned off
I am trying to sum filtered cells however when I turn the filter off the value of the summation changes as cells in between the ones I have selected are incorrectly included. Can anyone please help?...
If you have a relatively new version of Excel, you can use the FILTER function instead of the Filter icon on the toolbar. You don't provide a lot of info, however.
The formula would be something like =SUM(FILTER(range, criteria))
If you want more specific help, you could help us help you by posting a copy of the spreadsheet (or a mockup, if the real contains confidential info) on OneDrive or GoogleDrive, with a link pasted here that grants access.