Counting entries in two columns

[Esther]

Hello everyone,

I have a training schedule spreadsheet consisting of 5018
rows of data. Column 'D' contains the title of the course
each participant attended and in most cases this is
duplicated on different rows. This indicates the number
of participants that attended a particular course.
Column 'E' contains the date the training course held.
Some courses run 4 times in the year.

I want to count the number of participants that attended
each course on a particular day.

Any advice would be welcomed.

Thank you,

Esther

 

[Frank Kabel]

Hi
I would use a pivot table for this. see the following
sites for getting started with them:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm