Query Function

549 views

Skip to first unread message

Ronan

unread,

May 1, 2019, 11:36:32 AM5/1/19

to Google Visualization API

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?

Ray Thomas

unread,

Jul 14, 2019, 2:25:43 AM7/14/19

to Google Visualization API

An old thread but this should work

=Query(range,"Select C, sum(E) where C contains 'LIM67' and not C contains '+' group by C")

Reply all

Reply to author

Forward

0 new messages