Hello.
I have a SS that has different accounts. I have a COUNTIF working against a
column that puts together 3 aspects of the accounts that need to be counted
(G below), but how can I count the cust's that are unique (some customers
have more then 1 row)
A1: =COUNTIF(G2:G6,"COFNNA")

C D E F G
Cust # Franchise Cust Type Prod Type Formula
10001 Fran CO NNA
=E2&(IF(ISBLANK(D2),"NF","F"))&F2
10001 Fran CO NNA
=E3&(IF(ISBLANK(D3),"NF","F"))&F3
10002 CO NNA
=E4&(IF(ISBLANK(D4),"NF","F"))&F4
10003 CO NBB
=E5&(IF(ISBLANK(D5),"NF","F"))&F5
10004 NQ NNA
=E6&(IF(ISBLANK(D6),"NF","F"))&F6

How can I count column G but only if column C is unique?

On dec. 29, 22:25, InternJessica
wrote:
Hello.
I have a SS that has different accounts. *I have a COUNTIF working against a
column that puts together 3 aspects of the accounts that need to be counted
(G below), but how can I count the cust's that are unique (some customers
have more then 1 row)
A1: =COUNTIF(G2:G6,"COFNNA")

C * * * * * *D * * * * * * * * *E * * * * * * * * * *F * * * * * * * * * *G
Cust # * Franchise * *Cust Type * * Prod Type * * * * Formula
10001 * *Fran * * * * * * CO * * * * * * * *NNA * *
=E2&(IF(ISBLANK(D2),"NF","F"))&F2
10001 * *Fran * * * * * * CO * * * * * * * *NNA * *
=E3&(IF(ISBLANK(D3),"NF","F"))&F3
10002 * * * * * * * * * * * *CO * * * * * * * NNA * *
=E4&(IF(ISBLANK(D4),"NF","F"))&F4
10003 * * * * * * * * * * * *CO * * * * * * * NBB * *
=E5&(IF(ISBLANK(D5),"NF","F"))&F5
10004 * * * * * * * * * * * *NQ * * * * * * * NNA * *
=E6&(IF(ISBLANK(D6),"NF","F"))&F6

How can I count column G but only if column C is unique?

Try this:
=SUMPRODUCT((C2:C7<"")/COUNTIF(C2:C7,C2:C7&""),--(G2:G7="COFNNA"))
Regards,
Stefi

Try this:
=SUMPRODUCT((C2:C7<"")/COUNTIF(C2:C7,C2:C7&""),--(G2:G7="COFNNA"))

This is a duplicate message because I'm not sure that you'll be notified of
the original message sent via googlegroups.
Regards,
Stefi


--
Regards!
Stefi



€žInternJessica€� ezt Ã*rta:

Hello.
I have a SS that has different accounts. I have a COUNTIF working against a
column that puts together 3 aspects of the accounts that need to be counted
(G below), but how can I count the cust's that are unique (some customers
have more then 1 row)
A1: =COUNTIF(G2:G6,"COFNNA")

C D E F G
Cust # Franchise Cust Type Prod Type Formula
10001 Fran CO NNA
=E2&(IF(ISBLANK(D2),"NF","F"))&F2
10001 Fran CO NNA
=E3&(IF(ISBLANK(D3),"NF","F"))&F3
10002 CO NNA
=E4&(IF(ISBLANK(D4),"NF","F"))&F4
10003 CO NBB
=E5&(IF(ISBLANK(D5),"NF","F"))&F5
10004 NQ NNA
=E6&(IF(ISBLANK(D6),"NF","F"))&F6

How can I count column G but only if column C is unique?