Debugging errors in Google Sheets is not fun - unless you know how to read them.
This video walks through 3 common types of errors that pop up when running Query functions: #REF, #VALUE and #N/A errors.
For more background on the Query function, grab a copy of the Google Sheets formula cheat sheet at:
https://trello.com/c/b2q3P0E3/39-10-k...