Count unique values where multiple columns have data

[Spartin]

See below. I need to count the number of drivers (identified by their unique driver ID in ColumnA) who logged into a system over the given date range (in columns B-E). In the example below, the answer is 2. I'm having trouble counting the unique values given the multiple columns. Any help is appreciated. I am having problems with the formatting on the table below - sorry for about that.


A B C D E
Driver ID 7/1/17 7/2/17 7/3/17 7/4/17

1010003 1 1
1010008
1010011
1010013
1010118 1 1 1
1010121
1010128

 

[Spartin]

Very nice - thanks again for the help!

 

[Aladin Akyurek]

Very nice - thanks again for the help!

You are welcome.

 

[NiMip]

This board contains zillions frequency formulas for doing a unique count.

If the items to count are not just numbers...

Control+shift+enter:

=SUM(IF(FREQUENCY(IF(1-(A2:A8),IF(ISNUMBER(B2:E8),MATCH(A2:A8,A2:A8,0))),ROW(A2:A8)-ROW(A2)+1),1))

I tried using this and it doesn't seem to work for me. If the IDs are names and not numbers, then 1-(A2:A8) results in an error that is carried through the rest of the formula.

EDIT: In fact removing that IF statement solves the issue and the formula seems to work fine.

 

[Aladin Akyurek]

I tried using this and it doesn't seem to work for me. If the IDs are names and not numbers, then 1-(A2:A8) results in an error that is carried through the rest of the formula.

EDIT: In fact removing that IF statement solves the issue and the formula seems to work fine.

It’s

1-(A2:A8=“”)