The attached spreadsheet analyzes deliveries. My client wants to be able to count missed deliveries. A missed delivery is considered one where there is an arrival and departure time in the appropriate columns but no quantities in the Salt, P/E, Water or Chem columns (the products). There is a CountBlank in cell N28. It's counting the cells where there are no arrival and departure times. In this example it's showing 4 because there are four blank cells in the range but those cells don't have arrivals and departures so they're irrelevant. Is there a way to not count blanks if another cell in the same row is blank?