Okay, I'm submitting a sample spreadsheet but I hope you understand my question. I'm trying to create a formula that will count based on two criteria (two separate columns). A customer number and order date are the examples provided. In short, If column A is a number AND column B is not blank then count. In the example the result should be 3. Hope this makes since and apologies but I cannot provide a copy of the actual file for security reasons. Thank you in advance.