| Home |
| Search |
| Today's Posts |
|
#9
|
|||
|
|||
Thanks that worked.
"Nick" wrote: Hi Elizabeth Assuming your list of slaes orders in in column A and the name of the Project manager is in B and that the sales order is unique to a project manager then you can use this formula. =SUM(IF($B$1:$B$12=E1,1/COUNTIF($A$1:$A$12,$A$1:$A$12),0)) Cell E1 contains the name of the Manager. Copy this fromula in to cell F1 and enter as an Array formula (Crll+Shift+Enter) Enter the names in E2 etc and copy down to F2 etc. Nick "Elizabeth" wrote in message ... I have a list of records where the Project Manager has several numbers assigned to him but sometimes the number is duplicated. How do I use the CountIF so that it only counts the number once? Here is an example of my data: Sales Order Project Mgr 6100517416 Gomes 6100517416 Gomes 6100517424 Gomes 6100517424 Gomes 6100517425 Gomes 6100517425 Gomes 6100521493 DeVivo 6100531944 Sturm 6100531944 Sturm |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF COMBINATION?? | Excel Worksheet Functions | |||
| Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
| COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
| Countif - Countif | Excel Worksheet Functions | |||
| countif, again | Excel Worksheet Functions | |||
Threaded Mode
