Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 10 0 11 5 11 5 16 5
- 0 0 9 5 11 5 11 5
- 12 0 12 5 12 5 12 5
- 11 0 11 5 11 5 11 5
- =SUMPRODUCT(--(MOD(COLUMN(A1:H4),2))* (A1:H4=0)*(LEN(A1:H4)>0))
- =CONCATENATE("[", COUNTIF(A:A, 0), ";", COUNTIF(C:C,0), ";", COUNTIF(E:E,0), ";", COUNTIF(G:G,0), "]" )
- =sum(countif(a1:a4,0),countif(c1:c4,0),countif(e1:e4,0),countif(g1:g4,0))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement