I am using =COUNTIF(I12:I530,">50%"), but I can't figure out how to adjust this to a subtotal type where a auto and manual filter can be applied to this.


I would appreciate any help someone could provide.

Thank you so much!
Lauren

I was just asked if I could take this above criteria for multiple measures. IE. If an individual has >50% in I2, >80% in M2, >40% in N2, etc for 10 measures all greater than a percent. Could I place the word MET in a different cell? or at leat a Y or check mark?


Thanks again!