| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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!!!!  -- gj07435 ------------------------------------------------------------------------ gj07435's Profile: http://www.excelforum.com/member.php...o&userid=15956 View this thread: http://www.excelforum.com/showthread...hreadid=274340 |
|
#2
|
|||
|
|||
|
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!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| Help with a formula | Excel Discussion (Misc queries) | |||
| Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Hybrid Mode
