K
Kasimir Lehväsl
Hello,
I hope someone can help me
I'm trying to calculate a weighed average grade with excel
on one column are the credits:
e.g
2
4,5
6
2
3
and on the other column are the grades that correspond those blanks
(from 1-5)
e.g
2
3
4
(this course is not yet completed so here is a blank)
(same here)
Now how could I calculate the weighed average so that the entries with
blanks are ignored (the credits that correspond to the blanks are not
taken into the calculation)
Hope you understood my explanation
any help much appreciated
I hope someone can help me
I'm trying to calculate a weighed average grade with excel
on one column are the credits:
e.g
2
4,5
6
2
3
and on the other column are the grades that correspond those blanks
(from 1-5)
e.g
2
3
4
(this course is not yet completed so here is a blank)
(same here)
Now how could I calculate the weighed average so that the entries with
blanks are ignored (the credits that correspond to the blanks are not
taken into the calculation)
Hope you understood my explanation
any help much appreciated