Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Tariffs
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Tariffs
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. -- bob777 ------------------------------------------------------------------------ bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504 View this thread: http://www.excelforum.com/showthread...hreadid=512219 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Tariffs
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Tariffs
For say 100 items:
=SUMPRODUCT((A1:A100<"")/COUNTIF(A1:A100,A1:A100&"")) -- Gary''s Student "cj21" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Tariffs
Hi Niek,
I had a go at explaining it a while back in http://tinyurl.com/dhbxe -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Niek Otten" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Tariffs
Thanks, Bob!
-- Kind regards, Niek Otten "Bob Phillips" wrote in message ... Hi Niek, I had a go at explaining it a while back in http://tinyurl.com/dhbxe -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Niek Otten" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional counting with Excel | Excel Worksheet Functions | |||
conditional counting of autolist cells/rows | Excel Discussion (Misc queries) | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Counting... | Excel Worksheet Functions |