Subtotal with Filtering

[Sakalansalex]

I want to calculate "D04" Subtotal for "M" only in "D02" according to "Date" filter

Thanks a lot in advance

P.S.: I couldn't upload an Excel file

​

 

[jorismoerings]

Cross post: https://www.excelforum.com/excel-formulas-and-functions/1205565-subtotal-with-filtering.html

 

[Sakalansalex]

Here is a solution by 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