Formula for unique names in a range of columns

[Biking Loki]

I have a spreadsheet with names of different people in columns F, G, H, and I. Individual names may apprear multiple times in any of the columns.

Is there a formula that I can use to count the total number of names within the range of those columns so that multiple instances of a name are only counted once? I've figured out how to do it for a single column but not multiple columns.

TIA!
Loki

 

[Eric W]

If I understand correctly, this should work:

	F	G	H	I	J
1	Col1	Col2	Col3	Col4	Count
2	Joe	Andy	Tom	Bob	11
3	Jane	Julie	Terry	Andy
4	Mike	Kristin	Mike	Kristin
5	Amy	Mike		Hank
6		Hank
7		Joe
8
9
10

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet6​

Array Formulas Cell Formula J2 {=SUM(IF(F2:I10<>"",1/(COUNTIF(F2:I10,F2:I10))))} <thead> </thead><tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

 

[Biking Loki]

That worked perfectly. Thanks Eric!!

 

[Eric W]

Glad to help!