Not including duplicates in a count

[Dan in Oz]

G'day,

I have a spreadsheet that I use to keep training records. One of the columns
caontains a list of the companies represented in the training - there are
about 200.

In the bottom row, I have all the totals. But for the "Company" column, is
there a formula that I can use to count the participating companies i.e. not
counting the duplicates?

Any help will be much appreciated.

Thanks

Dan

 

[T. Valko]

This will count the unique entries in the range:

=SUMPRODUCT((A1:A100<>"")/COUNTIF(A1:A100,A1:A100&""))