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


--
Kasimir Lehväsl
------------------------------------------------------------------------
Kasimir Lehväsl's Profile: http://www.excelforum.com/member.php...o&userid=24902
View this thread: http://www.excelforum.com/showthread...hreadid=384376

Assuming your credits values are, for example, in A1:A5 and your grades in
B1:B5
then to total values use =SUMIF(B1:B5,"0",A1:A5)

"Kasimir Lehväsl" wrote:


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


--
Kasimir Lehväsl
------------------------------------------------------------------------
Kasimir Lehväsl's Profile: http://www.excelforum.com/member.php...o&userid=24902
View this thread: http://www.excelforum.com/showthread...hreadid=384376

yes it works!

Thanks alot! :) :)


--
Kasimir Lehväsl
------------------------------------------------------------------------
Kasimir Lehväsl's Profile: http://www.excelforum.com/member.php...o&userid=24902
View this thread: http://www.excelforum.com/showthread...hreadid=384376