Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting on multiple criteria | Excel Discussion (Misc queries) | |||
counting multiple criteria | Excel Worksheet Functions | |||
Multiple Counting Criteria | Excel Discussion (Misc queries) | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |