Countif Blanks with an OR function

Mary Royston

Hey!

I am trying to build out my metrics sheet, with a long Countifs formula with multiple criteria. One of the criteria I need is: Count the number of cells in a range if either of a date column is Blank. I keep getting the #INVALID DATA TYPE Error. My formula looks something like:

=OR(COUNTIF({Date Range 1}, ISBLANK(@cell)), COUNTIF({Date Range 2}, ISBLANK(@cell)))

Can someone please help?

Dakota Haeffner

Just a thought, have you tried using "" instead of ISBLANK?

For Example:

=OR(COUNTIF({Date Range 1}, ""), COUNTIF({Date Range 2}, ""))

If you Data Ranges are columns you should get a value returned if the cell is empty. If that doesn't work try adding in the @cell pieces.

Let me know if you have any luck!

I use this formula to track my User Acceptance Testers work statuses and it works for me.

=COUNTIFS({Request - UAT Assigned}, ="Teji XXXXX", {Request - Rally Status}, ="")