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 ...
Another 365 approach based upon the Lorenzo interpretation of your problem.
= BYROW(Data,
LAMBDA(d,
COUNTIFS(d, 0, hdr, "<>field2" )
)
)where "field2" is one of a set of column headers.
A key feature of the solution is that it exploits the fact that BYROW passes a set of Range References, not just an array of numbers.
A key feature of the solution is that it exploits the fact that BYROW passes a set of Range References, not just an array of numbers
Didn't realize/know that and it's really great - Thank you