Thread
:
Average for Grade
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Param
external usenet poster
Posts: 5
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?
Reply With Quote
Param
View Public Profile
Find all posts by Param