N column data is either "Win" or "Loss", now I'm trying to count them separately with
SUBTOTAL because I utilize filters quite often.
I'm trying something like this:
=SUBTOTAL(103, IF($N18:$N, "Win"))
But it won't work because subtotal needs a range rather than an if statement.
What would be the correct solution here?