Why doesn't my Excel total change when I filter the list to one session?
TechnologyI filtered our equipment list to Friday's session, but the SUM at the bottom still gives the quantity for the whole list. My colleague wants to delete the other sessions' rows so the number matches what we're looking at.
We need to keep the complete list. Microsoft documents SUBTOTAL for calculations that exclude filtered-out rows, with a further distinction between filtered rows and rows hidden manually. Microsoft's SUBTOTAL reference
How would you provide a clear total for the selected session without losing the overall total or the other sessions' records? The equipment desk needs to know what a number covers, not just see a number that changes.