Forum Discussion
Count the number of zero using countif function.
Hi there I had a simple excel sheet where I would like to count the number of zero in row A, B, C etc and so on. However, I would like to exclude column C to be counted. How would you write such ...
Hi evilgreenred
Assuming I understood (count by row, excluding 3rd column) with Excel 2021 or 365:
in J2:
=MMULT((Data=0) * (SEQUENCE(,COLUMNS(Data))<>3), SEQUENCE(COLUMNS(Data))^0)