GPA Calculator, problem - GPA Calculator.xls (0/1)

  • Thread starter Thread starter bentley_rhodes
  • Start date Start date
B

bentley_rhodes

Hey i'm in college and i'm trying to get Excel to do the Cumulative
GPA (not including classes i'm currently enrolled in), a semester GPA,
and a Combined GPA. the first two work but the third does not.

when i type in the formula =sum(d2/d1) works, when i type in the
formula =sum(h8:h11+d8:d24)/sum(f8:f11+b8:b24) it does not.


cumulative gpa
=sum(d8:d24)/(b8:b24) this should be 2.36 something
(i had a rough first year).


semester gpa
=sum(h8:h11)/(f8:f11) this should be about 3.0


Combined GPA
=sum(h8:h11+d8:d24)/sum(f8:f11+b8:b24)
when this works, it gives me a number
like 141. it should give me a number like 2.50 or 2.67.
 
You have misread the meaning of SUM. It is a function to summing a range of
cells as in SUM(A1:A20) to add up the cells A1+A2+A3...A20. It does not mean
"do this math"
So your =sum(d2/d1) should be simply =D1/D2
and your =sum(h8:h11)/(f8:f11) should be SUM(H8:H11)/SUM(F8:F11)
Now look at =sum(h8:h11+d8:d24)/sum(f8:f11+b8:b24)
Looks like you need =SUM(H8:H11,D8:D24)/SUM(F8:F11,B8:B24))
The syntax for SUM is =SUM(argument1, argument2, ...) where all but the
first argument are optional.

Not a bad GPA and improving. (sorry I'm a prof - or was until Sept 1, 2004)
 
Thanks! That works! The third did, that is! i still had to put the
'=' before the SUM for the others. Thank you, though!
 
Back
Top