Hi Chris,

Don't ask me how it works. I just copied it from a Google search.

=SUMPRODUCT((B1:B8<>"")/COUNTIF(B1:B8,B1:B8&""))

--
Kind regards,

Niek Otten

"cj21" <cj21.2381on_1139924401.4259@excelforum-nospam.com> wrote in message
news:cj21.2381on_1139924401.4259@excelforum-nospam.com...
>
> I have a list of products, each of which has a tarifff. e.g.
>
> Product...Tariff
> 01234563 10
> 01423467 10
> 01423578 20
> 13466989 5
> 10457904 25
> 14456893 30
> 20345076 5
> 34056097 20
>
> I want a formula that counts how many different tariff values there
> are. In this example there are 5. Is this possible?
>
> Thanks
>
> Chris
>
>
> --
> cj21
> ------------------------------------------------------------------------
> cj21's Profile:
> http://www.excelforum.com/member.php...o&userid=25673
> View this thread: http://www.excelforum.com/showthread...hreadid=512219
>