Forum Discussion
Subtotal
Hello, I'm trying to include the subtotal formula in a cell but once I unfiltered the cells the total changes. Is there a formula that will allow the total to not change? This is the tota...
If you want the formula to return the sum of values satisfying some condition even if the data are not filtered on that condition, use the SUMIF function or SUMIFS function
Good morning, Hans. Thank you for this suggestion. I will try it & if I need more help I will come back.