Hi,

You can use the COUNTIF() function as well.

1. Suppose your data is arranged as follows in range C19:E27

Session Date Name Occurrence
1 2/13/09 Mike Jones 1
1 2/13/09 Sue Day 2
1 2/13/09 Joe Blow 3
2 2/20/09 Wes East 1
2 2/20/09 Lars Lyes 2
3 2/22/09 Val Zunn 1
3 03-02-2009 Xara Qu 2
3 03-02-2009 Kyle Miles 3

2. Enter Occurrence in cell F19;
3. In cell F20, enter COUNTIF($C$20:$C20,C20)
4. In cell D30 and D31, enter 2 and 3;
5. In F30, enter =COUNTIF($F$20:$F$27,D30) and copy down


--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Excel-User-RR" wrote in message
...
Please lend expertise to the following dilemma: In the list below column A
contains repeating session numbers. Column B contains the session date.
Column C contains the person's name. How can I count the number of
sessions
with people attending in specific amounts? For example I would like to
know
how many sessions were attended by 2 people, by 3 people, by 4 people,
etc.
Each result would be in a separate cell. Thanks for your time and
assistance
with this Excel 2003 formula. Per the example the results should be: 2
people=1 session (#2), 3 people=2 sessions (#s 1 & 3).
A B C
1 2/13/09 Mike Jones
1 2/13/09 Sue Day
1 2/13/09 Joe Blow
2 2/20/09 Wes East
2 2/20/09 Lars Lyes
3 2/22/09 Val Zunn
3 3/2/09 Xara Qu
3 3/2/09 Kyle Miles