daily count of course enrollment from master sheet

I have a student enrollment workbook. Student information is entered on a master sheet (sheet1); A-date admitted, B-name, C-course enrollment.

The other sheets are monthly sheets displaying a row for each day, and columns for each program. This is to keep a numerical track of how many students are in each program.

Simple countif function with course name works for adding up the total. The difficulty comes in having the date pulled from sheet1 add up accordingly per day for only specific programs. We want it to show per day, where the count is up to.

With my vague description, I don't expect a solution but in your replies I hope to get closer to figuring out what to do.

My colleague wrote this, I'm including to add context.
=COUNTIFS(Applicants!A:A,Applicants!A:A="10/20/2011",Applicants!C:C,Applicants!C:C="Biology")

You've indicated you're using Excel 03, so you won't have access to the COUNTIFS function. You should be able to use a SUMPRODUCT instead, something like:
=SUMPRODUCT(--(Applicants!A1:A1000="10/20/2011"),--(Applicants!C1:C1000="Biology"))
Please note you can't use whole column references (like A:A).

Thank you for the quick response. I selected 2010, but it does seem like it's showing 03. In any case, we solved it through simple matching dates then countif for the values.

edit: I can't see where to mark the thread solved.

Consult the forum rules for details on how to mark a thread solved. (See #9)