I have a table
table1 with a matrix of n columns
[[column_1]:[column_n]] that contain dates or empty fields.
Also there's a column
[number] with integers.
I want to count all cells that contain a date in the past AND are in a row where the corresponding number is 0. How do I do that?
Only the first condition is easy:
But I don't get it to only consider rows in which the integer is 0.
I know there's probably an approach using array functions, but I can't figure it out. Searching on google was to no avail.
Thanks for your help!