I need to create a sum of all the prices associated with ID numbers that have a distinctive set of characters within them.
using =Query(Range,"Select C,E where C contains 'LIM67' and not C contains '+'",1) gets me the values I need but doesn't automatically add up the E column. Can anyone help please? -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/d5f1af67-71b3-4ff4-987d-eedd9e7eb766%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
