COUNTIFS - Multiple Columns if blank by person
I am looking to count by the person if they have not entered data in the cells within a column.
If person A is missing six (6) cells within three (3) different columns then the calculation should only calculate that person one (1) time. I have created helper columns to calculate how many people have missed entering data. Previous to my helper columns I created a formula in the sheet summary (info below) in hopes I could do it that way.
I am using this formula in my helper columns but the count is incorrect:
=COUNTIFS([Project End Date]@row, <=TODAY()) + COUNTIFS([Reason for Termination]@row, "") + COUNTIFS([Service Type]@row, "") + COUNTIFS(PRM@row, <>"")
For example, the count should reflect 0 since this person is not missing any data.
In this example, this count should reflect 1 since the person is missing data.
My goal is to be able to identify how many people have missing data within these three (3) columns. If it were only these two (2) people then it should calculate it as one (1) person is missing data.
I have attempted to count via the sheet summary but that was not working either. I would much prefer to use the sheet summary since it would make it easier for my widgets on the dashboard.
=COUNTIFS(PRM:PRM, <>"", [Service Type]:[Service Type], "", [Project End Date]:[Project End Date], <=TODAY(), [Reason for Termination]:[Reason for Termination], "")
Looking for some assistance, please. Thank you for taking the time to review.
Help Article Resources
Check out the Formula Handbook template!