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: `=COUNTIF(Table1[[column_1]:[column_n]];"<"&TODAY())`

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!

`=COUNTIF(Table1[@[column_1]:[column_n]];"<"&TODAY())*(table1[@[number]]=0)`

) and summarize them in a second step. (Don't forget the`@`

in the formula) – Máté Juhász Nov 23 '18 at 12:24