Nested Countif

**wayne75** · 06-03-2005, 10:48 AM

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

**Domenic** · 06-03-2005, 11:22 AM

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!

Duke Carey · 06-03-2005, 12:05 PM

=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
>
>

Duke Carey · 09-05-2005, 10:05 PM

=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
>
>

Duke Carey · 09-05-2005, 11:05 PM

=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
>
>

Duke Carey · 09-06-2005, 12:05 AM

=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
>
>

Duke Carey · 09-06-2005, 01:05 AM

=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
>
>

Duke Carey · 09-06-2005, 02:05 AM

=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
>
>

Duke Carey · 09-06-2005, 03:05 AM

=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
>
>