Use reference cells in the formula to create subtotal

[Burrelli]

This is the formula I have in cell H5
=SUMIF('GSC Data 16mo'!C:C, ">=10000", 'GSC Data 16mo'!B:B) - I need the literal to be replace be the subtotal of a filtered cell

C:C are Impressions and B:B are Clicks

What I need to have calculated in cell H5 is the total/sum of the Impressions Column C:C where the filter on B:B (Clicks Column) are greater than say 500 from a control/user input cell S5. So, return the total Impressions when the Total Clicks column is filtered by "x".

In my head...
=SUMIF('GSC Data 16mo'!C:C, [where 'GSC Data 16mo'!B:B, ">"&S5) ]

also need similar a SUMIFS version:

=SUMIFS('GSC Data 16mo'!C:C, 'GSC Data 16mo'!C:C, [where 'GSC Data 16mo'!B:B, ">"&S6) ], 'GSC Data 16mo'!C:C, [where 'GSC Data 16mo'!B:B, "<"&T6) ]

 

[awoohaw]

i'm happy you found a solution. Best wishes.