I need to count the total number of UNQIUE contracts, split between three categories. I have copied it in below for speed of reference
Package
Client1 Bronze 100,000
Client2 Gold
Client3 Gold 100,000 100,000
Client4 Gold
Client5 Bronze 100,000 75,000 100,000
Client6 Silver
Client7 Bronze 100,000
Client8 Gold 100,000
Client9 Silver
Client10 Silver 100,000 100,000 100,000
Client11 Silver
Client12 Silver 100,000 100,000
Client13 Bronze 100,000 100,000
Client14 Silver 100,000
Client15 Gold
Client16 Silver
Client17 Silver 100,000 100,000
Client18 Gold 100,000 100,000
Client19 Bronze
Client20 Bronze
Client21 Gold
Client22 Silver 100,000
Client23 Gold 100,000 100,000
Client24 Gold 100,000 100,000
Client25 Gold 100,000
Client26 Gold
100,000
Total 2 4 6 7 9 10
Bronze - 1 1 2 2
Silver 1 1 3 3 5
Gold 1 2 2 2 2 3
Hard entered actuals above
=SUMPRODUCT(N(MMULT(N($O5:U33>0),ROW(INDIRECT("1:"&COLUMNS($O5:U33)))^0)>0))
I know the above will count total of unique Clients but I want to bring into the sumproduct a way of counting total unique contracts
Bookmarks