Subtotal countif

Should be an easy one , but just wondered how to go about the following:

When I filter column B, I'd like the formula in A1 to take this into account & calculate a new % given the data on show

Thanks, Mdn

There's probably a better alternative but here's one option:

=SUMPRODUCT(SUBTOTAL(3,OFFSET(A2:A251,ROW(A2:A251)-ROW(A2),0,1)),--(A2:A251="WINNER"))/SUMPRODUCT(SUBTOTAL(3,OFFSET(A2:A251,ROW(A2:A251)-ROW(A2),0,1)),--(LEN(A2:A251)>0))

Note that the formula from post #2 is calculating the following:
(# cells that say WINNER) / (# cells that are not blank)

If you wanted this:
(# cells that say WINNER) / (# cells that say WINNER, SCRATCH, or LOSER)
then you can use this:

=SUMPRODUCT(SUBTOTAL(3,OFFSET(A2:A251,ROW(A2:A251)-ROW(A2),0,1)),--(A2:A251="WINNER"))/SUMPRODUCT(SUBTOTAL(3,OFFSET(A2:A251,ROW(A2:A251)-ROW(A2),0,1)),(A2:A251="WINNER")+(A2:A251="SCRATCH")+(A2:A251="LOSER"))

Ty Falcon excellent work

Happy to help. Thanks for the rep!