Forum Discussion
chwar750
Mar 31, 2025Copper Contributor
Help with Countif function (normal count unless another column states a certail text)
Hi all, I currently have a countif formula counting the number of projects staff members in my team are assigned to =COUNTIF('Work-Database'!E:E,"*Staff Member Name*") Ideally, I would like to ad...
HansVogelaar
Mar 31, 2025MVP
Use COUNTIFS:
=COUNTIFS('Work-Database'!E:E, "*Staff Member Name*", 'Work Database'!M:M, "<>Complete")