hat
1. Avèk fòmil ki anwo la a, ou ka konte selil ki pa zewo ki gen ladan selil vid yo. Si ou vle inyore tou de selil yo zewo ak selil vid, tanpri aplike fòmil sa a: =COUNTA(A1:D10)-COUNTIF(A1:D10,"=0"), Lè sa a, peze Antre nan kle yo jwenn rezilta a, wè D ':
eng
1. With the above formula, you may count the non-zero cells which including blank cells. If you want to ignoring both the zero cells and blank cells, please apply this formula: =COUNTA(A1:D10)-COUNTIF(A1:D10,"=0"), then press Enter key to get the result, see screenshot: