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 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 great tha a percent. Could I place the word MET in a different cell? or at leat a Y or check mark?
Thanks again!
may be countifs will work for your
If your problem is not solved, upload a sample workbook with sample data and your desired results
In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks