Excel Formula
 

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.


--
Newfie

Excel Formula
 

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

--
__________________________________
HTH

Bob

"Newfie809" wrote in message
...
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.


--
Newfie

Excel Formula
 

Thank you it works.
--
Newfie


"Bob Phillips" wrote:

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

--
__________________________________
HTH

Bob

"Newfie809" wrote in message
...
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.


--
Newfie