How do I set up this count?

[kmprice710]

I have a list of customers

Column 1: Account numbers
Column 2: Different departments attached to the account number.
Column 3: Supplier Shipment Numbers

I need to count how many times each specific department is listed under the same supplier shipment number. But I can't count departments without also including the Account number because supplier shipments sometimes include multiple accounts. So I dont want to accidentally count Finance Dept. for Account #101 appearances under transaction # 15 and include Finance Dept. for Account #201 appearances under transaction #15 but those Finance departments are completely separate departments.

How do I set up the count?

 

[Fluff]

Thinking about it, you could use

=SUMPRODUCT(($A$2:$A$800000=A2)*($B$2:$B$800000=B2)*($C$2:$C$800000=C2))