Hi there

I am struggling with sumproduct at the moment. This an extract of the spreadsheet I am working on:

Shares CP

1,600 WINS
40,631 WINS
Bulk WINS
Bulk WINS
35,354 WINS
31,826 WINS
Bulk WINS
7,101 ODL
15,438 WINS
6,000 WINS
Spouse WINS

I am trying to count up the number of deals done with a particular CP but not if they are "bulk or spouse" (e.g the numbe of deals done with WINS that aren't bulk or spouse = 6 and those done with ODL = 1).

Any help is gratefully received!

Thank you