Weighed average if the adjecent column contains blanks

[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

[bigwheel]

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
>
>

[Kasimir Lehväsl]

yes it works!

Thanks alot!