using a QUERY formulate in Google Spreadsheet
March 22, 2010 11:17 AM Subscribe
Hi, I searched through the archives and did not find a match. Thank you in advance. Let's say I have a spreadsheet in Google docs with two columns, names and dollar amounts. Jane Smith, $5; Joe Sixpack, $7; Jane Goodall, $4; Joe Frankin, $10, etc. I want to use – I think – the QUERY function to ADD up all the dollars that all the Joe's have, or all the dollars that the Jane's have. I have read through as much documentation as I can find and it's not giving me enough to formulate a successful query. This:
=query(A1:B20, "Select A where (A contains 'jane')", sum(B))does not work. Any suggestions? thank you!