Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ArrayFormula(QUERY(Sales!A:A&{"",""},"select Col1, count(Col2) where Col1 != '' group by Col1 label count(Col2) 'num sales'",1))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement