Results 1 to 5 of 5

daily count of course enrollment from master sheet

Threaded View

PLora daily count of course... 10-27-2011, 02:08 PM
davegugg Re: daily count of course... 10-27-2011, 02:21 PM
PLora Re: daily count of course... 10-27-2011, 02:57 PM
davegugg Re: daily count of course... 10-27-2011, 03:05 PM
PLora Re: daily count of course... 10-27-2011, 03:13 PM
  1. #1
    Registered User
    Join Date
    10-27-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2003
    Posts
    3

    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")
    Last edited by PLora; 10-27-2011 at 03:12 PM. Reason: solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1