I am struggling with a formula in Google Spreadsheet.Here is what I want to achieve:If a column in a book is not null and if another column in another book is having a specific value, then counting 1. Then summing up all rows.Example case: Defect tracking.If the test cases column 'defectID' has a value and that in another book, this defect does not have the status Closed (a specific column), then count it as 1.Here is the formula I have but it's failing:  =COUNTIFS(ISEMPTY('Test Cases'!N3:N), FALSE, Defects!I3:I,<>Closed)Would you know how I can combine functions to have this?
Formula counting based on two conditions
google spreadsheets