I'm working on some statistics for some classes at my school. I'm trying to have a formula that will calculate the median of ratings for the different classes. My formula I have is:
=MEDIAN(IF(Table1[Class]="AR",Table1[Rating]))
But I can not figure out why the IF statement doesn't output correctly into the MEDIAN Function.
From what I understand, the IF statement should look through column A's list of classes and see if they are "AR", if they are, they should output that value, if not, then output nothing. (I am aware that the output of nothing is not possible and it will output 0.)
If anyone could help, that would be great!
Aucun commentaire:
Enregistrer un commentaire