QUERY FUNCTION IN GOOGLE SHEETS -Facebook and Google Analytics Comparison

MCK Novisa

started a topic almost 2 years ago

HI!
(QUESTION TO ADVANCED USERS)

Can anyone point any error in my formulas?

I want to transfer data from one sheet to a column in another - matching the date.

After entering the formula - the column returns empty fields, and where it should be given is #ref.

That's why I wanted iferror formula to fill the field with zero.

After adding the iferror function - it does not work at all.

=QUERY('Google Analytics'!$A$2:$H$639;"SELECT E WHERE A=date'"&TEXT(A2;"yyyy-mm-dd")&"' and B='"&B2&"' and C='"&C2&"' and D='"&D2&"'")

=IFERROR(=QUERY('Google Analytics'!$A$2:$H$639;"SELECT E WHERE A=date'"&TEXT(A2;"yyyy-mm-dd")&"' and B='"&B2&"' and C='"&C2&"' and D='"&D2&"'"), 0)

(18.8 KB)

(20.3 KB)

(28.8 KB)