COUNTIFS Formula not working when I add an ISBLANK statement

Options

I have a COUNTIF formula that I can't get to work once I add an ISBLANK statement.


This is the fomula that works:

=COUNTIFS({Payment Type}, =$Status@row, {Case Date}, MONTH(@cell) = 8, {Case Date}, YEAR(@cell) = 2020, {Status}, ="Completed")


When I try to account for rows where the Payment Type is blank, I tried this formula:

=COUNTIFS({Payment Type}, ISBLANK(@cell), {Case Date}, MONTH(@cell) = 8, {Case Date}, YEAR(@cell) = 2020, {Status}, ="Completed")


However, I'm getting an #INVALID DATA TYPE error. What am I doing wrong?

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!