Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Nested Countif
Can anyone tell me if it is possible to nested countif's. I.e. Basically the following function =COUNTIF(O:O,NAME_OF_PERSON),COUNTIF(P:P,CALL_TYPE ) Basically I work in a sales office and the sales staff can either make a prospect call, a customer call or a supplier call. I need to be able to see how many Prospect calls John Smith has made, customer calls etc.......... Any help please would be greatly appreciated Wayne -- wayne75 ------------------------------------------------------------------------ wayne75's Profile: http://www.excelforum.com/member.php...o&userid=23669 View this thread: http://www.excelforum.com/showthread...hreadid=376300 |
#2
|
|||
|
|||
Try... =SUMPRODUCT(--(O1:O100="Person"),--(P1:P100="CallType")) If 'CallType' is a numerical value, remove the quotes. Also, note that SUMPRODUCT does not accept whole column references. Hope this helps! -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=376300 |
#3
|
|||
|
|||
=SUMPRODUCT(--(O1:O1000="person"),--(P1:P1000="call type"))
"wayne75" wrote: Can anyone tell me if it is possible to nested countif's. I.e. Basically the following function =COUNTIF(O:O,NAME_OF_PERSON),COUNTIF(P:P,CALL_TYPE ) Basically I work in a sales office and the sales staff can either make a prospect call, a customer call or a supplier call. I need to be able to see how many Prospect calls John Smith has made, customer calls etc.......... Any help please would be greatly appreciated Wayne -- wayne75 ------------------------------------------------------------------------ wayne75's Profile: http://www.excelforum.com/member.php...o&userid=23669 View this thread: http://www.excelforum.com/showthread...hreadid=376300 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF and Nested Functions? | Excel Worksheet Functions | |||
Countif Function -Nested | Excel Discussion (Misc queries) | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |