Formula to Sum(Count)

Hi, my first post here

After googling for an hour, I couldn't find an answer to my excel question - or perhaps I'm asking the wrong question. Here goes...

Attached is a snap shot of the issue. It shows two sets of data:

Example_1.xlsx

1) original data, and
2) a table created from a pivot table of original data, consolidated by customer code

In the consolidated table, I want to add two columns - by Customer
1) count of part numbers sold - only counting the part number once - as multiple transactions of the same part number may exist within each customer.
2) count of part numbers sold with existing contract price - only counting the part number once, same reason as step 1.

Is this something that can be ascertained in one formula?

Look forward to your replies.

Thank you.