COUNTIF in a filtered list with an "IF" formula...HELP!

[vllevy]

I need help creating a formula that will count cells with a specific value after the list is filtered. The added issue I'm running into is the COUNTIF AND SUMPRODUCT functions do not work for me when the value showing in the cell is the result from the formula assigned to the cell, rather than the value just being typed in. For example, I have an "IF" formula that returns the value "YES" for a specific calculation, but countif or sumproduct functions will not count that cell with the formula in it that results in "YES" being displayed. But they will count the cell if I type the letters 'YES' in there. Can someone tell me how to adjust my formula so it will count the cell with the formula in it that gives me the result/value I am looking for?

Here's the formula I am using to count the cells in the filtered list:
=SUMPRODUCT(SUBTOTAL(3,OFFSET(K6:K9400,ROW(K6:K9400)-ROW(K6),0,1)),--(K6:K9400="YES"))

Thank you.

 

[Domenic]

Make sure that there's no extra space within the text value "YES" returned by your formula. If there's no extra space, try posting a sample of the formula being used to return "YES".