Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average for Grade
Hi, I use below formula for marks(numbers)
For values in A1:A100 B1: =SUMIF(A1:A100,"0",A1:A100)/COUNTIF(A1:A100,"0") OR ARRAY FORMULA* B1: =AVERAGE(IF(A1:A1000,A1:A100)) My Question: How to modify this formula for grade? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average for Grade
Maybe something like
=LOOKUP(AVERAGE(IF(A1:A1000,A1:A100)),{0,50,60,70 ,80,90},{"F","E","D","C","B","A"}) as an array formula HTH Bob "Param" wrote in message ... Hi, I use below formula for marks(numbers) For values in A1:A100 B1: =SUMIF(A1:A100,"0",A1:A100)/COUNTIF(A1:A100,"0") OR ARRAY FORMULA* B1: =AVERAGE(IF(A1:A1000,A1:A100)) My Question: How to modify this formula for grade? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average for Grade
Hi,
How about this: from cell range A1:A5 contain grades (link from another sheet). example: B C D DIV/0 DIV/0 Question: because there is div/0, my average formula doesnt work. how to solve it? TQ "Bob Phillips" wrote: Maybe something like =LOOKUP(AVERAGE(IF(A1:A1000,A1:A100)),{0,50,60,70 ,80,90},{"F","E","D","C","B","A"}) as an array formula HTH Bob "Param" wrote in message ... Hi, I use below formula for marks(numbers) For values in A1:A100 B1: =SUMIF(A1:A100,"0",A1:A100)/COUNTIF(A1:A100,"0") OR ARRAY FORMULA* B1: =AVERAGE(IF(A1:A1000,A1:A100)) My Question: How to modify this formula for grade? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average for Grade
What is your average formula?
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Param" wrote in message ... Hi, How about this: from cell range A1:A5 contain grades (link from another sheet). example: B C D DIV/0 DIV/0 Question: because there is div/0, my average formula doesnt work. how to solve it? TQ "Bob Phillips" wrote: Maybe something like =LOOKUP(AVERAGE(IF(A1:A1000,A1:A100)),{0,50,60,70 ,80,90},{"F","E","D","C","B","A"}) as an array formula HTH Bob "Param" wrote in message ... Hi, I use below formula for marks(numbers) For values in A1:A100 B1: =SUMIF(A1:A100,"0",A1:A100)/COUNTIF(A1:A100,"0") OR ARRAY FORMULA* B1: =AVERAGE(IF(A1:A1000,A1:A100)) My Question: How to modify this formula for grade? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average for Grade
=average(A1:A5)
*actually I really dont know how to create formula for this question. TQ "Bob Phillips" wrote: What is your average formula? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Param" wrote in message ... Hi, How about this: from cell range A1:A5 contain grades (link from another sheet). example: B C D DIV/0 DIV/0 Question: because there is div/0, my average formula doesnt work. how to solve it? TQ "Bob Phillips" wrote: Maybe something like =LOOKUP(AVERAGE(IF(A1:A1000,A1:A100)),{0,50,60,70 ,80,90},{"F","E","D","C","B","A"}) as an array formula HTH Bob "Param" wrote in message ... Hi, I use below formula for marks(numbers) For values in A1:A100 B1: =SUMIF(A1:A100,"0",A1:A100)/COUNTIF(A1:A100,"0") OR ARRAY FORMULA* B1: =AVERAGE(IF(A1:A1000,A1:A100)) My Question: How to modify this formula for grade? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average for Grade
No, I meant what formula returns A, B, C etc and the Div/0
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Param" wrote in message ... =average(A1:A5) *actually I really dont know how to create formula for this question. TQ "Bob Phillips" wrote: What is your average formula? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Param" wrote in message ... Hi, How about this: from cell range A1:A5 contain grades (link from another sheet). example: B C D DIV/0 DIV/0 Question: because there is div/0, my average formula doesnt work. how to solve it? TQ "Bob Phillips" wrote: Maybe something like =LOOKUP(AVERAGE(IF(A1:A1000,A1:A100)),{0,50,60,70 ,80,90},{"F","E","D","C","B","A"}) as an array formula HTH Bob "Param" wrote in message ... Hi, I use below formula for marks(numbers) For values in A1:A100 B1: =SUMIF(A1:A100,"0",A1:A100)/COUNTIF(A1:A100,"0") OR ARRAY FORMULA* B1: =AVERAGE(IF(A1:A1000,A1:A100)) My Question: How to modify this formula for grade? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average for Grade
below are the links to the diferrent file.
A1='C:\EMS\[Class1.xls]S5'!$AF$78 A2='C:\EMS\[Class2.xls]S5'!$AF$78 A3='C:\EMS\[Class3.xls]S5'!$AF$78 A4='C:\EMS\[Class4.xls]S5'!$AF$78 A5='C:\EMS\[Class5.xls]S5'!$AF$78 ps- at cell AF$78 (there are another formula link to another sheet to get the answer) e.g AF78=Sheet1!$V$37 "Bob Phillips" wrote: No, I meant what formula returns A, B, C etc and the Div/0 -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Param" wrote in message ... =average(A1:A5) *actually I really dont know how to create formula for this question. TQ "Bob Phillips" wrote: What is your average formula? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Param" wrote in message ... Hi, How about this: from cell range A1:A5 contain grades (link from another sheet). example: B C D DIV/0 DIV/0 Question: because there is div/0, my average formula doesnt work. how to solve it? TQ "Bob Phillips" wrote: Maybe something like =LOOKUP(AVERAGE(IF(A1:A1000,A1:A100)),{0,50,60,70 ,80,90},{"F","E","D","C","B","A"}) as an array formula HTH Bob "Param" wrote in message ... Hi, I use below formula for marks(numbers) For values in A1:A100 B1: =SUMIF(A1:A100,"0",A1:A100)/COUNTIF(A1:A100,"0") OR ARRAY FORMULA* B1: =AVERAGE(IF(A1:A1000,A1:A100)) My Question: How to modify this formula for grade? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average Grade for Letters | Excel Discussion (Misc queries) | |||
how would i get an 'grade point average' using this formula | Excel Worksheet Functions | |||
i need need a grade sheet for average several assignments. | Excel Discussion (Misc queries) | |||
Grade book average formula | Excel Worksheet Functions | |||
Do any of the Grade book templates using Excel average grades? | Excel Discussion (Misc queries) |