Conditional counting with multiple criteria
 

I have a worksheet with 4 columns: Name, Course, Year, Mode.
Column Year contains the year a student is studying on a course (Yr1, Yr2,
Yr3) and Mode contains Part-time or Full-time.

I can easily count the number of students on a given course by using
countif() on the Course column. But how can I count the number of students
on, say, Electronics, Yr2, Full-time? Is there a database or lookup
function that would do this directly for me? The only solution I can come
up with is to introduce an additional column that concatenates the columns I
am interested in and then use countif() on this column searching, for
example, for "ElectronicsYr2Full-time"

Conditional counting with multiple criteria
 

Andrew wrote:
I have a worksheet with 4 columns: Name, Course, Year, Mode.
Column Year contains the year a student is studying on a course (Yr1,
Yr2, Yr3) and Mode contains Part-time or Full-time.

I can easily count the number of students on a given course by using
countif() on the Course column. But how can I count the number of
students on, say, Electronics, Yr2, Full-time? Is there a database
or lookup function that would do this directly for me? The only
solution I can come up with is to introduce an additional column that
concatenates the columns I am interested in and then use countif() on
this column searching, for example, for "ElectronicsYr2Full-time"

Perhaps I should have tried Google first!
http://exceltips.vitalnews.com/Pages...riteria. html