For this example I will use A1:A10, B1:B10, C1:C4 and D1:D4


A1:A10 = An Employee ID number; either 1, 2, 3, or 4
B1:B10 = 2 letters will be entered in these cells which represent a type of sale. "A" and "U"
C1:C4 = formula (where the totals will appear based on criteria entered in A1:A10 and B1:B10) Only count if "A" is entered
D1:D4 = formula (where the totals will appear based on criteria entered in A1:A10 and B1:B10) Only count if "U" is entered

Can someone help me with this? thanks