Advertisement
mayankjoin3

absolute grading excel

Dec 6th, 2024
8
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. =COUNTIFS(P8:P158, ">=91", P8:P158, "<=100")
  2. =COUNTIFS(P8:P158, ">=81", P8:P158, "<=90")
  3. =COUNTIFS(P8:P158, ">=71", P8:P158, "<=80")
  4. =COUNTIFS(P8:P158, ">=61", P8:P158, "<=70")
  5. =COUNTIFS(P8:P158, ">=51", P8:P158, "<=60")
  6. =COUNTIFS(P8:P158, ">=41", P8:P158, "<=50")
  7. =COUNTIFS(P8:P158, ">=31", P8:P158, "<=40")
  8. =COUNTIFS(P8:P158, ">=0", P8:P158, "<=30")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement