Need help with a formula
 

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!!!! :eek:


--
gj07435
------------------------------------------------------------------------
gj07435's Profile: http://www.excelforum.com/member.php...o&userid=15956
View this thread: http://www.excelforum.com/showthread...hreadid=274340

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!!!! :eek: