Apr 3, 2011 at 03:49 AM
Posts365Registration dateMonday February 7, 2011StatusContributorLast seenSeptember 30, 2013
Apr 4, 2011 at 04:21 AM
I am new with excel and want to do the follwing.
1. I have sheet of all students with their names, subjects and grades
2. I have another list "Summary" where I want to calculate average of students based on their subjects. like; Subject 1: Avg = 3
3. All this I want is without using filters functionality of excel through mouse clicks.
I am more familiar with SQL so this is what I am looking for (in excel);
Aveg sub= Avg (select numbGrade from students where subject="SP")
This should give me an average grades of all students for a specific subject.