Hi Folks - Me again ... Here's my scenario:

I have data arranged like this:

SiteID Attendance Count ComparisonField
1 20 Increase
1 10 Decrease
1 5 Same
1 25 Decrease
2 20 Increase
2 10 Decrease
2 5 Same
2 25 Decrease

I need a way to produce stats like this:

SiteName Attendance Groupings
Comparison Counts
# of
increase # of Decreases # of Same
1 12 or more 1
1 0
Between 8-11 0
1 0
Less than 8 0
0 1

So, for any given site, I'd like to count the number of increases, decreases
and sames for the attendance groupings. I tried a Pivot Table, bu could not
get the correct results. I'm think an array formula may do the trick. Any
ideas? Thanks.

Michael