Sum or Remove List Formatting Filtered Cells

[TheDigital]

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.

 

[Jeffrey Mahoney]

I would create a helper column. You could identify the different types each row has by that column. It could be text or number. Sumifs can consider multiple criteria. Even if you filter the data it still returns the same result.