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 total I need to display & the formula I used is =Subtotal (9, AC10:AC24) the cells are filtered.
This is the number I'm getting once I unfiltered the cells.
I also tried using Sum & Aggregate formulas. Please help. Thank you.
2 Replies
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.
