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 0 down vote favorite

I would like to use the query function to select values from two separate sheets add them together and do a less then comparison to another value. I have used named ranges for the data that I am trying to select from.

Does this make sense to anyone?

share|improve this question
Did any of the answers work for you? – Jacob Jan Tuinstra Apr 28 at 19:22
I never did get it to work, I am going to revisit the problem here in the coming months and see if I can try it again. – user31031 Apr 30 at 1:54
I you share a spreadsheet with us, we can make it work inside your spreadsheet. All you need to do, is give it edit rights. – Jacob Jan Tuinstra Apr 30 at 6:24

2 Answers

up vote 0 down vote

This is best done with the use of Google Apps Script. Make sure to install the following script, via the script gallery: enter image description here

The script you just installed, makes it possible to combine multiple ranges into one. The sheet Combined shows the result of that function: =VMERGE(Sheet1,Sheet2)

In the last sheet (Result) you can use the QUERY formula to perform the query you're looking for: =QUERY(Combined!A:A,"select A where A < 4")

See example file I've prepared for you to play with: VMERGE and QUERY

share|improve this answer
up vote -1 down vote

The QUERY and QUERY API information pages on Google drive may be of help in creating a solution.

share|improve this answer
I have read both of those pretty thoroughly. I am thinking I am going to have to take a different route. – user31031 Dec 29 '12 at 17:25
Could you be more specific in what you're trying to do? The question was somewhat vague (hence the vague answer). For example, are you trying to COMBINE data from two sheets together by doing a less than comparison OR ADDING data values together and then comparing those values with each other? – whentimeslows Jan 11 at 23:37

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.