Calculating Grade Percentage Excluding Blank Cells

[annrbennett]

Please help....
I need a formula that will calculate the total percentage, excluding blank cells (assignments not yet graded).
Currently, I get 52.50% by dividing the sum of column B by the sum of column C, but that's not correct because I need the blank cells to be excluded.
Any suggestions???

A	B	C
Assignment	Points Received	Points Possible
HW 1	3	5
HW 2	5	5
HW 3	3	5
HW 4	5	5
HW5	5	5
HW6		5
HW7		5
HW8		5

<tbody>
</tbody>

 

[rossmack2129]

hi annrbennett,

To do what you need to do you could either use a subtotal with a filter or alternatively use a sumif to only sum column C values when column B isn't blank.

In this case you could use:

=SUM(B$2:B9)/SUMIF(B$2:B9,"<>"&"",C$2:C9)


In the above we assume your data is running from B2:B9 and C2:C9 - just change these to fit your data requirements.

Hope that helps,

Cheers,
Ross