Forum Discussion
Subtotal If
Hello! I have created a sumif formula that allows me to calculate the total hours my day's todo list will take me. For my work excel I have a list of things to do and what days I plan to complete t...
I found no one formula in your sample, but in general to work with filtered rows you may add helper column with formula as
=AGGREGATE(3,5,B5)which returns 1 if row 5 is visible and 0 if hided.
Or you may use SUBTOTAL() which ignore hided/filtered cells.
- This is brilliant. With this as a helper column you can create the equivalent of a SUBTOTALIFS.
