Excel Kriterli Subtotal (Alttoplam)

=SUMPRODUCT(SUBTOTAL(9,OFFSET(B3:B6,ROW(A3:A6)-MIN(ROW(A3:A6)),,1)),--(A3:A6="çek"))