Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average Grade for Letters andreah Excel Discussion (Misc queries) 3 January 30th 07 11:38 AM
how would i get an 'grade point average' using this formula VD Excel Worksheet Functions 4 December 24th 06 06:21 PM
i need need a grade sheet for average several assignments. GANDALF Excel Discussion (Misc queries) 1 December 10th 05 05:04 PM
Grade book average formula Will in SF Excel Worksheet Functions 5 October 23rd 05 09:19 PM
Do any of the Grade book templates using Excel average grades? JHardin Excel Discussion (Misc queries) 0 June 29th 05 07:59 PM


All times are GMT +1. The time now is 12:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"