Last updated on Jun 26, 2026, 5:12 PM
| Formula | Problem Where It Works | Example (Not Executed) | Use Case | ▶️ YouTube |
|---|---|---|---|---|
| GOOGLEFINANCE Historical | How do I analyze historical stock performance? | =GOOGLEFINANCE("GOOG","close",TODAY()-30,TODAY()) | Historical prices | |
| NETWORKDAYS.INTL | How do I calculate workdays with custom weekends? | =NETWORKDAYS.INTL(A1,B1,"0000011") | Custom workdays | |
| WORKDAY.INTL | How do I calculate future business dates with custom weekends? | =WORKDAY.INTL(A1,30,"0000011") | Business dates | |
| DATEDIF | How do I calculate age in months between two dates? | =DATEDIF(A1,B1,"YM") | Age/month calculation | |
| SPARKLINE | How do I display trend charts inside cells? | =SPARKLINE(B2:M2)' | Mini charts | |
| FREQUENCY | How do I analyze the distribution of values into groups? | =FREQUENCY(A:A,{10,20,30,40}) | Distribution analysis | |
| MMULT | How do I perform matrix multiplication in Google Sheets? | =MMULT(A1:C3,E1:G3) | Matrix multiplication | |
| TRANSPOSE + QUERY | How do I create pivot-style reports from horizontal data? | =QUERY(TRANSPOSE(A1:Z2),"SELECT *") | Pivot-like reporting | |
| COUNTIF | How do I count all records matching a specific value? | =COUNTIF(A:A,"Paid") | Count matching values | |
| COUNTIFS | How do I count records matching multiple criteria? | =COUNTIFS(A:A,"Paid",B:B,"Yes") | Multiple conditions | |
| GOOGLEFINANCE | How do I pull live stock market data into Google Sheets? | =GOOGLEFINANCE("GOOG") | Financial data | |
| GOOGLETRANSLATE | How do I translate text automatically in Google Sheets? | =GOOGLETRANSLATE(A1,"en","es") | Translate text | |
| IMPORTXML | How do I scrape specific information from a webpage? | =IMPORTXML("https://example.com","//title") | Scrape web data | |
| IMPORTHTML | How do I import tables from a website? | =IMPORTHTML("https://example.com","table",1) | Import tables | |
| IMPORTRANGE | How do I pull data from another Google Sheet? | =IMPORTRANGE("URL","Sheet1!A:C") | Import other sheets | |
| IMAGE | How do I display images directly inside spreadsheet cells? | =IMAGE("https://example.com/image.jpg") | Display image | |
| SPARKLINE | How do I create mini charts inside a single cell? | =SPARKLINE(A1:A10) | Mini charts | |
| XLOOKUP | How do I return a custom message when a lookup fails? | =XLOOKUP(E2,A:A,C:C,"Not Found") | Modern lookup | |
| ARRAYFORMULA | How do I calculate an entire column automatically? | =ARRAYFORMULA(B2:B*C2:C) | Entire column calculations | |
| ARRAYFORMULA + VLOOKUP | How do I perform lookups for an entire column at once? | =ARRAYFORMULA(VLOOKUP(E2:E,A:C,3,FALSE)) | Bulk lookups | |
| MAP | How do I apply custom logic to every value in a range? | =MAP(A2:A,LAMBDA(x,x*10)) | Apply custom logic | |
| BYROW | How do I calculate totals for every row automatically? | =BYROW(A2:D10,LAMBDA(r,SUM(r))) | Row calculations | |
| BYCOL | How do I calculate averages for every column automatically? | =BYCOL(A2:D10,LAMBDA(c,AVERAGE(c))) | Column calculations | |
| REDUCE | How do I accumulate values into a single result? | =REDUCE(0,A1:A10,LAMBDA(a,b,a+b)) | Accumulation | |
| SCAN | How do I create running totals automatically? | =SCAN(0,A1:A10,LAMBDA(a,b,a+b)) | Running totals | |
| MAKEARRAY | How do I generate a custom array without manual entry? | =MAKEARRAY(5,5,LAMBDA(r,c,r*c)) | Dynamic arrays | |
| LET | How do I reuse a calculation within a formula? | =LET(x,SUM(A:A),x*0.1) | Reusable variables | |
| LAMBDA | How do I create my own custom function? | =LAMBDA(x,x*2)(10) | Custom functions | |
| CHOOSECOLS | How do I return only selected columns from a dataset? | =CHOOSECOLS(A:F,1,3,5) | Extract columns | |
| CHOOSEROWS | How do I return only selected rows from a dataset? | =CHOOSEROWS(A:F,2,4,6) | Extract rows | |
| WRAPROWS | How do I convert a single column into multiple rows? | =WRAPROWS(A1:A20,5) | Reshape data | |
| WRAPCOLS | How do I convert a single column into multiple columns? | =WRAPCOLS(A1:A20,5) | Reshape columns | |
| HSTACK | How do I combine multiple columns into one table? | =HSTACK(A:A,B:B,C:C) | Merge columns | |
| VSTACK | How do I combine data from multiple sheets vertically? | =VSTACK(Sheet1!A:C,Sheet2!A:C) | Combine tables | |
| TOCOL | How do I convert a table into a single column? | =TOCOL(A1:D10)' | Convert to one column | |
| TOROW | How do I convert a table into a single row? | =TOROW(A1:D10)' | Convert to one row | |
| REGEXEXTRACT | How do I extract numbers from text strings? | =REGEXEXTRACT(A1,"[0-9]+") | Extract numbers | |
| REGEXMATCH | How do I validate email domains in Google Sheets? | =REGEXMATCH(A1,"gmail\.com") | Email validation | |
| REGEXREPLACE | How do I remove non-numeric characters from phone numbers? | =REGEXREPLACE(A1,"[^0-9]","") | Clean phone numbers | |
| TEXTJOIN + FILTER | How do I create a dynamic comma-separated list? | =TEXTJOIN(", ",TRUE,FILTER(A:A,B:B="Yes")) | Dynamic lists | |
| IMPORTRANGE + QUERY | How do I build reports from external spreadsheets? | =QUERY(IMPORTRANGE("URL","Sales!A:F"),"SELECT Col1,Col3") | Remote reporting |