|You could do somthing like this: |
With your data like this:
A B C D
1) List Total Date Course
2) RL.1.1 2 04/15/2013 RL.1.1
3) RL.1.2 0 04/22/2013 RL.1.6
4) RL.1.3 1 04/29/2013 RL.1.3
5) RL.1.4 0 05/06/2013 RL.1.1
6) RL.1.5 0
7) RL.1.6 1
8) etc. etc.
Column A is your course list, not sure how they are numbered.
To make life easier, we are going to Define a Name for the list.
Select your list of cells,
If you have 20 RL courses then it should be A2 : A21.
On the Ribbon, Select the Formula Tab
Select Define Name
In the popup window, enter a name for your list, like: RL_Courses
Check at the bottom of the window that the Refers To box
show the correct range of cells. Something like: =Sheet1!$A$2:$A$21
Were going to jump over Column B to column C which is simply the Date
a RL course was taught, which you input manually.
Column D is your Drop Down list of RL Courses.
Back to Column B, which is your Totals column and has the formula:
It will count, in column D, from row 2 thru row 44
the number of times each course is selected.
See how that works for you.