Hallo, Das geht meiner Meinung nach nicht,eine Query gibt ja immer eine Tabelle zurück versuche es mit COUNTIF
LG Olaf 2016-07-02 23:46 GMT+02:00 Matthew Rhea <[email protected]>: > I have a query that returns two values, MAX and COUNT. I don't want the > headers returned. I can get rid of one header, but not both. Any ideas on > how I can get rid of both headers? I know I can write two queries instead, > one getting COUNT and one getting MAX, but I'd like to use just one query. > > =QUERY(Dates!$A$2:$C$999,"SELECT COUNT(C), MAX(C) WHERE A = "&A2&"LABEL > COUNT(C) ''") > > Thanks, > Matthew > > -- > 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. > -- 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.
