Forum Discussion
evilgreenred
Jan 02, 2023Copper Contributor
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 ...
Lorenzo
Jan 02, 2023Silver Contributor
For Excel versions < 2021 a SUMPRODUCT option:
in J2:
=SUMPRODUCT(--((COLUMN(A2:H2)-COLUMN(A:A)+1)<>3), --(A2:H2=0))