Donate. I desperately need donations to survive due to my health

Get paid by answering surveys Click here

Click here to donate

Remote/Work from Home jobs

Query for the Google spreadsheet - 2º Part

on

I started my query on this post : Query for the Google spreadsheet

Now i'm modifying that query to make it a little bit more complexe, my problem is on the last part, when i use where col6="" and col6="" and col8="". That part is not working but i dont have any error.

=if(AND(B1=0;B2=0;D1=0);IMPORTRANGE("LINK"; "Llista!A6:S1000");if(AND(B1>1;B2>1;D1=0);query(IMPORTRANGE("LINK"; "Llista!A6:S1000");"select * where Col6='"&B1&"' and Col8='"&B2&"'");query(IMPORTRANGE("LINK"; "Llista!A6:S1000");"select * where Col6='"&B1&"' and Col6='"&D1&"' and Col8='"&B2&"'")))

Comments

Post a Comment