COUNTIF NON DUPLICATED ROWS


I

InternJessica

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?
 
Ad

Advertisements

S

Stefi

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
 
Ad

Advertisements

S

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:
 

Top