Search through sheet and count how many cells are blank in a specific column

[lockarde]

Hello all,

I have a spreadsheet that I fill out as customer requests come in - each request typically takes up 3 rows; the first row contains titles for each column (I know this is redundant, but it needs to be very clear for upper management as they sift through), the second row is details regarding the request, and 3rd row is a "notes" row (this is where some requests can take up more than 3 rows - I add a "notes" row if changes need to be made after the initial completion). As each request comes in, I fill in the request date, and as I complete the request, I fill in the completion date. If possible, I'd like a counter at the top of each month's spreadsheet that shows the "Completed Requests" and another one that counts "Incomplete Requests". I was thinking that I could use some combination of COUNTIF, VLOOKUP and ISBLANK, but I can't seem to get that to work, this could likely be due to incorrect format/syntax, so I figured I'd ask on here if anyone has done something like this, or if anyone has a more elegant solution. I would like this to be a formula, not using VBA if that's possible. I've attached an example of what the typical customer request rows look like below, with some edited column names, and details due to confidentiality conflicts:

Thanks for all the help!
lockarde

 

[Yongle]

With ... request date in column J and comp date column K

Assuming that ...
- that there are no other NUMBERS in either column
- that you want to take account of EVERYTHING that is in either column
- that there is NEVER anything in K if J is empty

Total Requests
=COUNT(J:J)

Total Completed
=COUNT(K:K)

Therefore Total Not Completed
=COUNT(J:J) - COUNT(K:K)