My project task sheet has parent rows for each department and child row for each project within the parent department. Each project row has a LEAD DEPT column with dropdown options that show the department acronym and business unit---DEPARTMENT (Unit).
The LEAD DEPT options are;
- DCM (Marketing)
- DCM (Membership)
- DCM (Publications)
- LEARNING (MCET)
- LEARNING (PD)
I am trying to create a "COUNTIF" formula that will count the total number of rows where the LEAD DEPT includes the acronym "DCM" and ignores the units. Using the options above, I want a formula that returns a value of "3".
