Forum Discussion
Solved
Excell "Spill"
Let me try to explain. I have dates in column A and data in column E to be counted in different ways. Some E cells will be blank and some with different data. What I’m trying to do is count blank ...
As variant that could be
=IFERROR( ROWS( FILTER( A2:A10000, ( A2:A10000 = TODAY() )* ( E2:E10000 = "" ) ) ), 0 )- Thank you Sergei very much. I'll give this a try. There have been several suggestions. I'm happy to try them all.
- Thank you very much. I'll give this a try. There have been several suggestions. I'm happy to try them all.
