COUNTIFS Formula not working when I add an ISBLANK statement

S_Karkhoff

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?

L_123

month(@cell)=8

month day and year formulas pop an error when used on a blank cell. use this to replace your month(@cell)

iferror(month(@cell),0)=8

*you should also do this for your year formula

S_Karkhoff

Thank you, that worked!

L_123

month(@cell)=8

month day and year formulas pop an error when used on a blank cell. use this to replace your month(@cell)

iferror(month(@cell),0)=8

*you should also do this for your year formula

S_Karkhoff

Thank you, that worked!