Subtotal with Filtering

In this Sheet, I need to get subtotal according to filter.


Thanks a lot in advance :) :)

Welcome to the forum!

=SUBTOTAL(109,F2:F12)

Quote:

---

Originally Posted by Kenneth Hobson

Welcome to the forum!

=SUBTOTAL(109,F2:F12)

---

Thank you Mr. Kenneth for your help, but unfortunately the formula didn't fit my demand :confused:

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 :cool: :cool: