Tell me more ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.
up vote 1 down vote favorite

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 myBoleanColumn 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 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 at 19:10

1 Answer

up vote 0 down vote

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

Here is the formula to count the Yeses in a column (or row): =COUNTIF(Q2:Q375,YES)

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

 
discard

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.