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!
gt;I cannot get the results only the formula shows.
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
quot;Terraquot; gt; wrote in message
...
gt;I am trying to complete transcripts with the GPA. Next to each rows, I
gt;have
gt; figured the IF formula of the students grades, (quality). I now need to
gt; add
gt; the sum of the quality and divide by the total credits earned. How do I
gt; find
gt; the SUM of IF. I tried the SUMIF formula, and even the SUM, but I cannot
gt; get the results only the formula shows.
gt;
- Jun 22 Fri 2007 20:38
sum of if formula
close
全站熱搜
留言列表
發表留言