Good afternoon,
Please could you advise where i would put the following array:
{QUERY;{"TOTAL",SUM($E$5:$E)}}
...in this query:
=IFERROR(QUERY(IMPORTRANGE("sheetname","INVOICE_ENTRY!B2:J"), "SELECT *" & IF ((LEFT(G4,1))="*", "WHERE Col7 STARTS WITH '"& RIGHT(G4,LEN(G4)-1) &"' AND Col1 CONTAINS '"&A4&"' AND Col2 CONTAINS '"&B4&"' AND Col3 CONTAINS '"&C4&"' AND Col4 CONTAINS '"&D4&"' AND Col6 CONTAINS '"&F4&"' AND Col8 CONTAINS '"&H4&"' ", "WHERE Col1 CONTAINS '"&A4&"' AND Col7 CONTAINS '"&G4&"' AND Col2 CONTAINS '"&B4&"' AND Col3 CONTAINS '"&C4&"' AND Col4 CONTAINS '"&D4&"' AND Col6 CONTAINS '"&F4&"' AND Col8 CONTAINS '"&H4&"' ")),)
Thanks for your help!
Best regards
Manc
Please could you advise where i would put the following array:
{QUERY;{"TOTAL",SUM($E$5:$E)}}
...in this query:
=IFERROR(QUERY(IMPORTRANGE("sheetname","INVOICE_ENTRY!B2:J"), "SELECT *" & IF ((LEFT(G4,1))="*", "WHERE Col7 STARTS WITH '"& RIGHT(G4,LEN(G4)-1) &"' AND Col1 CONTAINS '"&A4&"' AND Col2 CONTAINS '"&B4&"' AND Col3 CONTAINS '"&C4&"' AND Col4 CONTAINS '"&D4&"' AND Col6 CONTAINS '"&F4&"' AND Col8 CONTAINS '"&H4&"' ", "WHERE Col1 CONTAINS '"&A4&"' AND Col7 CONTAINS '"&G4&"' AND Col2 CONTAINS '"&B4&"' AND Col3 CONTAINS '"&C4&"' AND Col4 CONTAINS '"&D4&"' AND Col6 CONTAINS '"&F4&"' AND Col8 CONTAINS '"&H4&"' ")),)
Thanks for your help!
Best regards
Manc