I'm trying to write a SUMIF formula that permits filtering. Can anyone help with this?
If you want to sum B2:B100 when the corresponding value in A2:A100 = "x", only considering visible rows after filtering, then you can use a formula like this
=SUMPRODUCT(SUBTOTAL(9,OFFSET(A2,ROW(A2:A100)-ROW(A2),0)),(B2:B100="x")+0)
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks