Again - thanks for the laugh! You eased my frustration level.
When you used that formula, did you get the result of 9? I cut-n-pasted that formula into cell E2 and got 1. So I dragged the formula down to E26 - got 1's on all orders shipped on 3/4 and #VALUE! on all orders shipped on 3/1. So I added up the 1's and got 14. That's the same result my COUNTIF formula was giving me. I'm trying to get a formula that will spit me out the correct answer of 9 for this example. There are 9 unique order numbers from the list that shipped out on 3/4.