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?

Thanks,

John

Hi John,

try this *untested* formula:

=SUMPRODUCT((NOT(ISBLANK(A2:A10)))*(ISBLANK(B2:B10)))

Based on your example., try:

=SUMPRODUCT(NOT(ISBLANK(C8:C27))*NOT(ISBLANK(D8:D27))*(M8:M27=""))

in N28...

Martin

Perfect! Thank you Martin! You are the KING!

You're

1) too kind

2) welcome

M.