Combine SumIF and Subtotal

[yodaflex]

Please help, I have been attempting to follow other posts to do this but have been unsuccessful. I need to combine the following two formulas:

=SUBTOTAL(9,H3:H143)
=ROUNDUP((SUMIF($E$3:$E$143,$F$158,H3:H143))/240,0)


Column H are the values I want to subtotal based on if the value in F158 appears in Column E of the filtered list.

 

[pgc01]

Hi
Welcome to the board

=SUMPRODUCT((E3:E143=F158)*SUBTOTAL(3,OFFSET(E3,ROW(E3:E143)-ROW(E3),0)),H3:H143)

 

[yodaflex]

Thank you! Worked Perfectly!

 

[pgc01]

You're welcome. Thanks for the feedback.