Table has two columns: Assigned and Completed.
I want to count the number of rows that are Assigned, but not Completed.
Current solution is to copy this formula to every row (which provides a 1 or 0 depending on the conditions), then sum the results. Not very elegant. Would like a matrix (Ctrl-Shift-Enter) formula if possible
=--IF(AND(NOT(ISBLANK(Schedule!A6))=FALSE),ISTEXT(Schedule!B6)=TRUE)
The first part of this give a TRUE when an item is Completed, the second gives a TRUE when the item is assigned. The "--" turns TRUE/FALSE to 1/0 so they can be counted.
Bookmarks