Hello! I'm a bit new to the API query system, and I'm attempting to create a formula that works as follows:
=QUERY(A1:B20,"select A, sum(B) where A contains 'Apples' or A contains 'Oranges' group by A") So, the table looks something like this: Apples 3 Oranges 4 Melons 1 Apples 6 Apples 2 And I need it to return results like: Apples 11 Oranges 4 Melons 1 The formula works for that purpose, but the list of different fruits that can go into Column A is extensive. Is there any way I can do something like: =QUERY(A1:B20,"select A, sum(B) where A contains 'Sheet2!A2:A' group by A") Please let me know if I need to clarify what I'm trying to do, heh. -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
