Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have the following sheets:

  • ListA
  • ListB
  • ListC

Note: at each sheet I have a column which contains YES or NO.

How do I query all my lists (spreadsheets) where myBooleanColumn equals to YES/NO?

share|improve this question
What are you looking for? Just a count of the Yes/No's in each list on a 4th, separate sheet? – OnenOnlyWalter Jan 18 '13 at 18:46
@OnenOnlyWalter: Imagine that I have multiple lists and I wan to appear the rows that have been marked with ”YES/NO” at a certain column. Looked up to forums, blogs and other websites but haven't managed to reach to correct formula. Do you have an ideea? – el.severo Jan 18 '13 at 19:10
@el.severo: Please edit your question to include this important information. Comments are impermanent. – Al E. May 24 '13 at 12:53
Would it be possible to share an example spreadsheet ? That would make it a lot easier to help you. – JPV Apr 18 '15 at 18:31
up vote 1 down vote accepted

Assuming that all your sheets are in the same spreadsheet and the range of interest is A:B where column B have values YES/NO and you want only the rows where B is equal to YES, then the following formula should work:

=QUERY({ListA!A:B;ListB!A:B;ListC!A:B}, "select Col1, Col2 where Col2='YES'")

QUERY - Docs editors Help

share|improve this answer

First off, I'm going to assume you mean multiple SHEETS within the same SPREADSHEET. I know Google Spreadsheets can't search between multiple SPREADSHEETS.

Here is the formula to count the Yeses in a column (or row):


You could put one of these on each sheet and then sum them on a "report" sheet or cell. If you didn't want that count visible on each sheet put the cell out of range somewhere.

If you only want to show the YES rows on a sheet then use the built in filtering functions.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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