=SUMPRODUCT(--($A$2:$A$20=1),--($C$2:$C$20="Decrease"),--($B$2:$B$2012))

=SUMPRODUCT(--($A$2:$A$20=1),--($C$2:$C$20="Decrease"),--($B$2:$B$208),--($
B$2:$B$20<=11))

etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Michael" wrote in message
news:pWPDf.148428$WH.75374@dukeread01...
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