Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum of if formula
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum of if formula
Hi!
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 "Terra" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Nesting questions | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |