Counting Tariffs

C

cj21

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
 
B

bob777

Why not put a pivot table to the side of your data and use it to list
all tariffs - as a bonus it will tell you how many of each there are.
 
N

Niek Otten

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&""))
 
Top