Exclude Filtered Rows in SUBTOTAL

Hello,

I need to exclude filtered rows in a subtotal formula.

I have seen solutions using SUMPRODUCT and OFFSET but I'm having a problem figuring out how to use this solution with my specific example.

I have a spreadsheet with 3 columns. All input is contained in A5:C14. Column A contains a flag ("x") that is manually entered. Column B contains labels that I filter on. Column C contains amounts. Once I filter on specific labels in column B, I would like to sum only the rows that contain "x" in column A and ignore any hidden rows in my sum.

Here are the solutions I found on another post (substituting # for the data I need to enter):

=-SUMPRODUCT(SUBTOTAL(3,OFFSET(##,ROW(##:##)-ROW(##),,1)),-(##:##=#),(##:##))

or

=SUMPRODUCT(SUBTOTAL(9,OFFSET(##,ROW(##:##)-ROW(##),0)),--(##:##=#))

Can anyone help fill in the #'s to fit my example above?

Thanks!

Thank you. This is looking better. I got a number, rather than a VALUE error. Both formulas are summing column C for all of the filtered rows. I would like to see a sum for only the rows that contain "x" in column A. Is there a way to do that?

This works perfectly. Very impressive !

Thanks so much and I will mark as solved and click on Add Reputation.