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 ...
Detlef_Lewin
Jan 02, 2023Silver Contributor
=(B1=0)+(D1=0)