Create a Formula that compares Dates in 2 Columns and Counts a Total
I am trying to write a COUNTIFS formula that compares multiple criteria.
I need to Count all items in a column that have a status of "Completed" (column A), IF the items also have an Actual End Date within 2019 (column , and the Actual End Date is less than or equal to the Scheduled End Date (column C).
I cannot add another column to the source sheet. I am creating all formulas in a separate "Formulas sheet". Therefore, I need the formula to be setup so that it just delivers the "answer"....Ex. 4 items in Column A meet the above criteria.
Can anyone help guide me with this?
Help Article Resources
Check out the Formula Handbook template!