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" wrote in message
...
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