Skip to content

Instantly share code, notes, and snippets.

@brandonsheppard

brandonsheppard/how.md

Created September 5, 2019 23:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save brandonsheppard/551f272c6c95bc510238fe9fa32a05cc to your computer and use it in GitHub Desktop.
Save brandonsheppard/551f272c6c95bc510238fe9fa32a05cc to your computer and use it in GitHub Desktop.
Download ZIP
Sum and search by content and date (parsed) in Google visual query language
Raw
how.md 
=iferror(sum(query(Transactions!$A:$F,"select D where B contains '"&$A11&"' and A = date '"&text(F$1,"yyyy-mm-dd")&"'")))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment