In this Sheet, I need to get subtotal according to filter.
Thanks a lot in advance
[Solved] Subtotal with Filtering
In this Sheet, I need to get subtotal according to filter.
Thanks a lot in advance
Last edited by Sakalansalex; 10-25-2017 at 02:57 PM. Reason: Solved
Welcome to the forum!
=SUBTOTAL(109,F2:F12)
Thank you Mr. Kenneth for your help, but unfortunately the formula didn't fit my demandOriginally Posted by Kenneth Hobson
Here is a solution from a friend;
The formula is:
=SUMPRODUCT(SUBTOTAL(109;OFFSET(F3;ROW($F$3:$F$12)-ROW(F3);;1));--($D$3:$D$12="M"))
Thank you all for your help
Posting Permissions
Reply With Quote
Bookmarks