| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Team Deals
Is there a formula to highlight and/or count the number of team deals.
Ideally, I'd like to count the number of team deals so I can put it into a table and graph the results. Here are the parameters: Team A consists of the following members: John, Joe, Bob Team B consists of the following members: Shannon, Susan, Sally A B 1 John Susan 2 Joe Sally 3 Bob John 4 Susan Shannon 5 Sally Bob 6 Sally Shannon I need a formula that will count Team A Deals (row 3) and Team B Deals (row 4/6) with the following results. Team A Deals = 1 Team B Deals = 2 Help!!! Thanks in advance... you guys are the BEST! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Microsoft Excel Formula Help | Excel Worksheet Functions | |||
| Determine which team has to look at error again. | Excel Discussion (Misc queries) | |||
| Counting number of forwarding and sending back | Excel Discussion (Misc queries) | |||
| Barb Reinhardt: HOW TO: Plot a Team Name .... | Charts and Charting in Excel | |||
| HOW TO: Plot a Team Name on a chart based on two values | Charts and Charting in Excel | |||
Threaded Mode
