Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. =query(A:B,"Select A, Count(B) where A is not null and B='A' group by A,1")
  2.  
  3. ={"Data", "Count Amount";
  4. ARRAYFORMULA(QUERY({UNIQUE(A3:A),
  5. IFERROR(VLOOKUP(UNIQUE(A3:A),
  6. QUERY(A:B, "select A,count(B)
  7. where A is not null
  8. and B='A'
  9. group by A
  10. label count(B)''", 0), 2, 0), 0)},
  11. "where Col1 is not null"))}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement