In my Google sheet I'm getting an error:

Unable to parse query string for Function QUERY parameter 2: NO_COLUMN:

I've added a dropdown so the formula will auto-update depending on the tab selected.

Here's the formula that I'm getting an error:

=AVERAGE(query(""&B1&""&C1&"!!A2:I","Select Col9 where Col2='"&A5&"'"))

And here's the formula that's working:

=AVERAGE(query('2019年5月'!A$2:I,"Select I where B='"&A5&"'"))

Can somebody help me with this, please?

  • Welcome. Please see if you can edit your answer and provide a link to a sample spreadsheet or/and form. Your question is quite vague. Also please read How to Ask and About asking May 20, 2019 at 10:23

1 Answer 1


=AVERAGE(QUERY({INDIRECT(B1&C1&"!A2:I")}, "select Col9 where Col2 = '"&A5&"'"))


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.