Get Union Count Over Multiple Columns -- Excel

Question

Would like to what excel functions can count the row numbers when at least one column contains certain values? For example, from the below table, if I want to get the row number with at least one column being NULL, the answer should 3

header	A	B	C
First	'NULL'	'NULL'	'NULL'
Second	'NULL'	'WORD'	'NULL'
Third	'WORD'	'NULL'	'WORD'

Answer 1

With Excel365 you do it like-

=COUNTA(FILTER(A2:A4,(B2:B4="Null")+(C2:C4="Null")+(D2:D4="Null")))

If it is truly null means blank then use-

=COUNTA(FILTER(A2:A4,(B2:B4="")+(C2:C4="")+(D2:D4="")))