Count multiple blank columns

cyndi2403

Hello,

I have a task board with multiple columns like Original Due Date, Current Due Date, Goal, and Status.  I am trying to come up with a formula that "audits" the data for blanks so we can easily see that Person A has 5 tasks that have blank columns they need to fill out. 

In the formula below [Column7]$20 is the person's name.  I have figured out how to count based on one column (Current Due Date) but I think I need some kind of OR statement to say count if Current Due Date OR Original Due Date OR Goal OR Status are blank.  I haven't been able to figure out the syntax for this.  Any help is appreciated...thanks in advance!

 

=COUNTIFS({Product Team Task Board Assigned To}, [Column7]$20, {Product Team Task Board Current Due Date}, ="")

Paul Newcome

You would need to write a separate COUNTIFS for each column and then add them together.

 

=COUNTIFS(......................., {Current Due Date}, ...........) + COUNTIFS(......................., {Original Due Date}, ...........) + COUNTIFS(......................., {Goal}, ...........) + COUNTIFS(......................., {Status}, ...........)

cyndi2403

Thank you Paul!  Seems so obvious now.

Paul Newcome

Happy to help!