Google Sheets Functions
How to Use COUNTIF to Count TRUE in Google Sheets
Learn how to use COUNTIF, ARRAYFORMULA, SUMPRODUCT, and more to count TRUE values effectively in Google Sheets with flexible methods.
Read article
Google Sheets Functions
47 articles
Google Sheets Functions
How to Use VLOOKUP to Return Multiple Values in Google Sheets
Learn how to use VLOOKUP for multiple values in Google Sheets with FILTER, TEXTJOIN, QUERY, ARRAYFORMULA, and Apps Script alternatives.
Read article
Google Sheets Functions
How to Use SUMIF in Google Sheets If Another Cell Contains Text
Learn how to use SUMIF in Google Sheets when another cell contains text, with exact or partial matches, SUMIFS, FILTER, and ARRAYFORMULA.
Read article
Google Sheets Functions
How to Use VLOOKUP with a Drop-Down List in Google Sheets
Learn how to use VLOOKUP with a drop-down list in Google Sheets to fetch data dynamically, including setting up dependent drop-downs.
Read article
Google Sheets Functions
How to Use SUMIF with Multiple Criteria in Google Sheets
Learn how to use SUMIF with multiple criteria in Google Sheets using SUMIFS, wildcards, cell references, or SUMPRODUCT for OR conditions.
Read article
Google Sheets Functions
How to Fix IMPORTRANGE Internal Error in Google Sheets
Fix IMPORTRANGE internal errors in Google Sheets by granting access, checking sheet names, using correct URLs, and testing before nesting.
Read article
Google Sheets Functions
How to Fix 'Error Loading Data' in IMPORTRANGE in Google Sheets
Learn how to fix the “Error Loading Data” in IMPORTRANGE in Google Sheets by checking sheet names, ranges, access, and URL format.
Read article
Google Sheets Functions
How to Use ARRAYFORMULA with VLOOKUP in Google Sheets
Learn how to use ARRAYFORMULA with VLOOKUP in Google Sheets to apply lookups across rows, return unique results, and summarize form data.
Read article
![[Fixed] VLOOKUP Not Working in Google Sheets: 4 Cases](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-google-sheets-vlookup-not-working-c3d58a04.webp)
Google Sheets Functions
[Fixed] VLOOKUP Not Working in Google Sheets: 4 Cases
Discover how to fix VLOOKUP errors in Google Sheets, including #N/A issues, wrong values, formatting problems, and range errors.
Read article
Google Sheets Functions
SUMIF If Cells Are Not Blank Cells in Google Sheets (3 Examples)
Learn how to use SUMIF, FILTER, and SUMPRODUCT in Google Sheets to sum values only when cells are not blank for accurate results.
Read article
Google Sheets Functions
COUNTIF to Count Cells by Fill Color in Google Sheets (2 Ways)
Learn how to count cells by fill color in Google Sheets using Google Apps Script or a manual helper column for accurate tracking.
Read article
Google Sheets Functions
Return Value in Another Cell If Cell Contains Text in Google Sheets
Learn how to return a value in another cell if a cell contains text in Google Sheets using IF with SEARCH, EXACT, or REGEXMATCH functions.
Read article