sum of if formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to complete transcripts with the GPA. Next to each rows, I have
figured the IF formula of the students grades, (quality). I now need to add
the sum of the quality and divide by the total credits earned. How do I find
the SUM of IF. I tried the SUMIF formula, and even the SUM, but I cannot
get the results only the formula shows.
 
Hi!
I cannot get the results only the formula shows.
Click to expand...

The cell is probably formatted as TEXT. Change the format to GENERAL. Then,
with that cell selected, press function key F2 then hit ENTER.

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating %'s with IF and Sum/SumIF 12
Changing GPA to Ltr Grade 8
IF AND Nested Functions - Formula Not Working 0
Excel formula, sum the value cell and if empty cell left blank 0
Summing Values/Outputs of IF formulae 18
IF formula, Partial word, SUM function as result 1
Time Sum in Excel 1
How do I sum cells that have values from a text formula? 4

Back
Top