I've come across this solution to combining sumif and subtotal formula but I don't understand it..
Combining SUMIF() and SUBTOTAL() for Dynamic Subtotal
Could anyone please offer an explanation of the the way this set of functions works together so that it can be understood by other inexperienced users (like me)? This solution obviously solves the question but is very difficult to adapt for a different dataset, without some more insight. (I'd rather not post my own specific question because if I did, the next person with this query will have the same problem!)
Thanks!