Hi
try using a pivot table. See:
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

--
Regards
Frank Kabel
Frankfurt, Germany


gj07435 wrote:
I am trying to figure out what formula to use to do the following:

Count the number of incoming calls and then to break them down by
Council district (1 through 11). In addition, there are two types of
incoming calls (a "2" or a "3").

So, I must sort by CD and by call type. Make sense. Help!!!!