How to sum visible content in one column that contains specific text in another column.

[GTT]

Hello,

I have this formula to count the number of rows that contain "US" =SUMPRODUCT((SUBTOTAL(3,OFFSET(L4,ROW(L4:L227)-ROW(L4),)))*(L4:L227="US"))

I would like to modify this formula to sum the amounts in column H4:H227 that match this criteria in column L above namely containing US.

Thank you,

 

[Fluff]

Try

=SUMPRODUCT((SUBTOTAL(3,OFFSET(L4,ROW(L4:L227)-ROW(L4),)))*(L4:L227="US")*(H4:H227)

 

[GTT]

Try

=SUMPRODUCT((SUBTOTAL(3,OFFSET(L4,ROW(L4:L227)-ROW(L4),)))*(L4:L227="US")*(H4:H227)

Excellent. Works great. Thank you.

 

[Fluff]

You're welcome & thanks for the feedback.