Count unique customer number based off different column criteria

**CRM4567** · 11-21-2014, 12:22 PM

I am trying to count the number of accounts in columns D with revunue greater than 0, based off the unique customer number in column A.

**Ace_XL** · 11-21-2014, 12:29 PM

Try this array formula

=SUM(IF(FREQUENCY(IF(D5:D102>0,MATCH(A5:A102,A5:A102,0)),ROW(A5:A102)-ROW(A5)),1,0))

Confirm with Ctrl+Shift+Enter and not just Enter

**CRM4567** · 11-21-2014, 12:59 PM

Thank you, that worked great.

Cindy

Count unique customer number based off different column criteria

LinkBack

Thread Tools

Rate This Thread

Display

Count unique customer number based off different column criteria

Re: Count unique customer number based off different column criteria

Re: Count unique customer number based off different column criteria

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] count unique records in one column based on criteria in a different column

[SOLVED] Count unique entries based off unique criteria in another column

Count unique occurrances based off criteria in a different column

Count number occurences based on criteria Column

Count Unique Occurrences in one column based on criteria another column

Bookmarks

Bookmarks

Posting Permissions