Hi all
I'm trying to count the blank cells where the status is not closed using this formula
=IF(B2:B6,"<>Closed",COUNTBLANK(A2:A6))
However, I'm getting a #VALUE error. Any suggestions on why it wouldn't work? Thanks!
<tbody>
</tbody>
I'm trying to count the blank cells where the status is not closed using this formula
=IF(B2:B6,"<>Closed",COUNTBLANK(A2:A6))
However, I'm getting a #VALUE error. Any suggestions on why it wouldn't work? Thanks!
Data | Status |
2 | Closed |
2 | In Process |
Closed | |
3 | Closed |
Open | |
Open |
<tbody>
</tbody>