Count Rows that are Open and Closed based with another condition
Hello, I tried to do a search here, but could not find what I was looking for. I have a sheet with each row being opened and closed with a date range. I would like to count the rows that have an open date but no closed date, and also count rows that have the closed date populated with any date. I also need to add a condition of Division that has 4 different values. My thought was to count rows that have the Division populated and the Closed column was blank. Here was my best attempt
=COUNTIFS(Division:Division, "D16", Closed:Closed, 'ISBLANK'())
My second count would be the Division and the Closed has any date, but since I couldn't get the first one, I haven't got as far as a draft formula.
Any help appreciated
Help Article Resources
Check out the Formula Handbook template!