Monday, October 22, 2012

yogi_Compute Number Of Students Per Class And Number Of Sections For Each Class

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #821  Oct 23, 2012

user Monty2012 said: (!category-topic/docs/spreadsheets/1i7EMI-AyE0)
Sumif formal that only counts a unique criteria one time
I suspect this is an easy fix, but I think I've been over thinking it for too long.

I need a formula that will sum the number in Column A (Number of Students)  based on Criteria from Column B (Title of the Class), but I only want it to add the number once based on data from Column C (Class Section Number).  

My goal:  From a list of many class (ENGL, EDUC, POLI SCI) types, I want to know how many students from ENGL 101 attended a presentation, but some ENGL sections attended the presentation twice. I need to prevent double counting the students in the section that attended twice.
following is a solution to the problem
please check your posted results ... with mine and let me know