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?

  • What are you looking for? Just a count of the Yes/No's in each list on a 4th, separate sheet? Commented Jan 18, 2013 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
    Commented Jan 18, 2013 at 19:10
  • 1
    @el.severo: Please edit your question to include this important information. Comments are impermanent.
    – ale
    Commented May 24, 2013 at 12:53
  • Would it be possible to share an example spreadsheet ? That would make it a lot easier to help you.
    – JPV
    Commented Apr 18, 2015 at 18:31

2 Answers 2


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


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.

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.