Google Sheet Formula Samples

You will see some formula samples below. Please think what they mean. If you have any questions related any of them, please write them in in the comments.


if(COUNTBLANK($A8:$M8)=0,transpose(query(Directory!N$2:N$3)),"No")

QUERY(ImportRange("1qchEnmIzpT9zP82hTJCPEgKIADb-j2Obci7X-PUkLa4/edit#","Form Responses 1!A:N"), "Select Col13,Col4,Col5,Col6,Col7,Col9 where Col11='APPROVED' order by Col6 desc")

QUERY(Home_Visit!A:N, "select * where ( E='' or F='' or G='' or H='' ) and (I!='' or J!='' or K!='') and ( toDate(now() ) > E) ")

query(Main!1:1223,"select B, E, I, M, N, O where H contains '"&C3&"' and D contains '"&D3&"' and E contains '"&E3&"' order by B asc ",1)

QUERY('Lesson Plan'!A69:B215, "select * where A contains '"&C3&"' ")

AVERAGE(if(today()>$D$1,E3),if(today()>$F$1,G3),if(today()>$H$1,I3),if(today()>$J$1,K3),if(today()>$L$1,M3),if(today()>$N$1,O3))

ARRAYFORMULA( COUNTIFS($B$2:B,G2, DAYS360($C$2:C,$D$2:D)-2, ">0"))

IFERROR(SUM(FILTER(Tutoring_MS!H:H,Tutoring_MS!G:G=$Z$3,Tutoring_MS!B:B=B3)*$AA$3,FILTER(Tutoring_HS!H:H,Tutoring_HS!G:G=$Z$7,Tutoring_HS!B:B=B3)*$AA$8)/43,"0")

sort(unique(filter(Main!H2:H1223,Main!H2:H1223<>"",Main!G2:G1223=B3,Main!C2:C1223="2015-16")))

query(AddCourse!$A:$C,"select B where C matches """&F1&"""",0)



Comments

Popular posts from this blog

iBoss Tips&Problems

Synology DiskStation Quick Installation

Sonicwall; Open a port and how to use sonicwall wizard