Greetings, I have the following formula which counts the number of employee terminations by month and year, but needing the count to be only if text in another column (range: L55:L200) includes "*Sales*". Similarly if the count within that range does NOT include "*Sales*".
=SUMPRODUCT((MONTH(Table3[Date of Termination])=Y55)*(YEAR(Table3[Date of Termination])=Z55))
Any help is greatly appreciated.
=SUMPRODUCT((MONTH(Table3[Date of Termination])=Y55)*(YEAR(Table3[Date of Termination])=Z55))
Any help is greatly appreciated.