Hi,

So I'm doing a basic grade to GPA spreadsheet. Column I has the letter grade that is picked from a drop down list that references a simple named list on another worksheet. Column J has the following:

=IF(I2="A","4",IF(I2="B","3",IF(I2="C","2",IF(I2="D","1",IF(I2="F","0",IF(I2="",""))))))

I then have J16 do this:

=SUM(J2:J15)

The problem is J16 only returns 0. Also, how would I have J16 sum then divide the result by the number of cells that have a value in J2:J16 ?

Thanks in advance