Advertisement
Guest User

Untitled

a guest
May 7th, 2015
241
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. 10 0 11 5 11 5 16 5
  2. 0 0 9 5 11 5 11 5
  3. 12 0 12 5 12 5 12 5
  4. 11 0 11 5 11 5 11 5
  5.  
  6. =SUMPRODUCT(--(MOD(COLUMN(A1:H4),2))* (A1:H4=0)*(LEN(A1:H4)>0))
  7.  
  8. =CONCATENATE("[", COUNTIF(A:A, 0), ";", COUNTIF(C:C,0), ";", COUNTIF(E:E,0), ";", COUNTIF(G:G,0), "]" )
  9.  
  10. =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