Count Rows that are Open and Closed based with another condition

Randy Van Winkle
Randy Van Winkle ✭✭✭
edited 12/09/19 in Formulas and Functions

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!