I have a table with COUNTIF formulas that has a column (Data tab = H) where VLOOKUP formulas pull dates showing whether a project is completed or not. I need to only count active projects where a condition is that the date is blank. My current formula counts all, including the completed, giving me a wrong count on In Progress projects... please see attached sample... thx
Bookmarks