I have people registering for events on one google form. in my response
spreadsheet, i have the query function set to delineate which event
(currently class 1 -5) each person has selected onto a separate tab .
However, if someone signs up for multiple classes (using the multiple
choice
Trying to write a dynamic QUERY that will update based on additional
database addresses that will be added in the future.
I have a cell which formats and concatenates the various database addresses
which I am able to directly paste into the 1st argument of the QUERY
function, but when I try
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
Can the query function read more than one parameter?
I have used an 'OR' to try and make it work, but it keeps giving me parse
error
="select * where (col37='PRD-TEMP' OR Col37='PRD-MFG')"
--
--
You received this message because you are subscribed to the Google Groups
"Google