TheDigital
New Member
- Joined
- Jul 1, 2022
- Messages
- 3
- Office Version
- 2021
- Platform
- Windows
Greetings!
Been stumped looking for tutorials on how to either to sum filtered cells that isn't dynamic and doesn't change the number when the filtered is changed or possibly a way to be able to highlight cells from a filter and keep the cell names for a simple sum formula instead of auto-ormatting to a list.
Either two options would help with trying to calculate the sum of multiple values from a filtered list to be entered on another sheet but I can't seem to find any solution for this other than holding ctrl and clicking on each cell that I want to use in the sum formula.
Any assistance with this would be greatly appreciated.
Been stumped looking for tutorials on how to either to sum filtered cells that isn't dynamic and doesn't change the number when the filtered is changed or possibly a way to be able to highlight cells from a filter and keep the cell names for a simple sum formula instead of auto-ormatting to a list.
Either two options would help with trying to calculate the sum of multiple values from a filtered list to be entered on another sheet but I can't seem to find any solution for this other than holding ctrl and clicking on each cell that I want to use in the sum formula.
Any assistance with this would be greatly appreciated.