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