COUNTIFS WITH CONTAINS
I am trying specify counting only rows that contain "UO" within the Department column, are less than one year and the withdraw/rescind column is blank. I am able to achieve the counting of withdraw/rescind less than one year with the below formula, but when I add contain I continue to get the response #INCORRECT ARGUMENT SET. What am I missing in the CONTAINS formula that is not generating the correct data?
=COUNTIFS([Entry Date]:[Entry Date], >TODAY(-365), [Withdrew/Rescind Reason]:[Withdrew/Rescind Reason], "", CONTAINS("UO", Department:Department))
Help Article Resources
Check out the Formula Handbook template!