Excel Formula

[Newfie809]

I have a spreadsheet with around 8000 rows and 16 columns, with about 30
course codes.

This is a example of my spreadsheet:

C F L
Course Code Semester Students
CHV2O1 1 25
CHV2O1 1 20
CHV2O1 2 19
GLC2O1 1 20
GLC2O1 2 16

I would like to retrun a total of the number of Students in Semester 1
taking CHV2O1 (45), Semester 2 (19) etc.. Hope you can help thanks.

 

[Bob Phillips]

=SUMPRODUCT(--(C2:C200="CHV201"),--(F2:F200=2),L2:L200)

 

[Newfie809]

Thank you it works.
--
Newfie

=SUMPRODUCT(--(C2:C200="CHV201"),--(F2:F200=2),L2:L200)

--
__________________________________
HTH

Bob