PLEASE HELP! i have been working on this for days

I need to find the number of Unique Customer accounts associated with certain criterias......


For example i need to see how many see how many unique customer Id's have bougth form us if OEM NAme is "1" The Team is "LOB",the Date entered is "PRE" and the status is "PO"

Mind you i have 222,222 Rows i am working with


Status Data Entered OEM Name Teams Company ID
PO PRE 1 LOB 55
NS POST 5 Tournoux 66
RTN PRE 6 Balsdeasari 55
NS POST 9 LOB 88
PO PRE 8 Tournoux 99
NS POST 7 Balsdeasari 2
RTN POST 4 LOB 8
NS PRE 1 Tournoux 4
PO POST 3 Balsdeasari 9
NS PRE 10 LOB 17
RTN POST 11 Tournoux 1458
NS POST 2 Balsdeasari 9
PO PRE 6 Balsdeasari 408
NS POST 6 LOB 446
RTN PRE 7 Tournoux 485
NS POST 7 Balsdeasari 524
PO POST 7 LOB 563
NS PRE 7 Tournoux 601
RTN POST 7 Balsdeasari 640
NS PRE 7 Balsdeasari 679
PO POST 7 LOB 718
NS POST 7 Tournoux 756
RTN PRE 8 Balsdeasari 795
NS POST 8 LOB 834
PO PRE 8 Tournoux 873
NS POST 8 Balsdeasari 911
RTN POST 8 Balsdeasari 950
NS PRE 8 LOB 989
PO POST 8 Tournoux 1028
NS PRE 8 Balsdeasari 1066
RTN POST 9 LOB 1105
NS POST 9 Tournoux 1144
PO PRE 9 Balsdeasari 1183
NS POST 9 Balsdeasari 1221
RTN PRE 9 LOB 1260
NS POST 9 Tournoux 1299
PO POST 9 Balsdeasari 1338
NS PRE 9 LOB 1376