Google Sheets Functions
How to Use COUNTIF to Count Non-Blank Cells in Google Sheets
Learn how to use COUNTIF in Google Sheets to count non-blank cells, even across ranges, while ignoring specific values and extra spaces.
Read article
Google Sheets Functions
47 articles
Google Sheets Functions
How to Return a Value If Cell Color Is Red in Google Sheets
Learn how to return a value if a cell color is red in Google Sheets using Apps Script, conditional formatting with helper columns, or add-on.
Read article
Google Sheets Functions
How to Show 0 Instead of Blank in Google Sheets
Learn how to show 0 instead of blank in Google Sheets using IF, IFERROR, ISBLANK, ARRAYFORMULA, N function, or Apps Script for full control.
Read article
Google Sheets Functions
Google Sheets QUERY GROUP BY Multiple Columns (3 Examples)
Group data by multiple columns in Google Sheets using the QUERY function. Learn to filter with WHERE and sort results for better insights.
Read article
Google Sheets Functions
How to Use Google Sheets QUERY to Order by Multiple Columns
Learn how to use Google Sheets QUERY function to sort data by multiple columns like join date and salary for better organization & analysis.
Read article
Google Sheets Functions
How to Concatenate Multiple Cells in Google Sheets
Learn how to concatenate multiple cells in Google Sheets using CONCATENATE, TEXTJOIN, JOIN functions, or the ampersand (&) operator.
Read article
Google Sheets Functions
How to Use VLOOKUP from Another Sheet in Google Sheets
Learn how to use VLOOKUP from another sheet in Google Sheets within the same workbook or between workbooks using IMPORTRANGE.
Read article
Google Sheets Functions
How to Use IF Formula in Google Sheets with Multiple Conditions
Learn how to use the IF formula in Google Sheets with multiple conditions by combining IF with AND, OR, and using the IFS function.
Read article
Google Sheets Functions
How to Use Google Sheets QUERY with Multiple Criteria
Learn how to use the Google Sheets QUERY function with multiple criteria using AND, OR, NOT operators to filter and exclude data effectively.
Read article
Google Sheets Functions
How to Use IMPORTRANGE in Google Sheets with Conditions
Learn how to use IMPORTRANGE in Google Sheets with conditions by combining it with QUERY, FILTER, helper columns, and multiple criteria.
Read article
Google Sheets Functions
How to Count Unique Values in Google Sheets (5 Simple Ways)
Learn how to count unique values in Google Sheets using COUNTUNIQUE, UNIQUE with COUNTA, COUNTIF, SUMPRODUCT, and FLATTEN for advanced cases.
Read article
Google Sheets Functions
How to Count Non-Empty Cells in Google Sheets
Learn how to count non-empty cells in Google Sheets using COUNTA, COUNTIF, and ARRAYFORMULA while filtering spaces and applying conditions.
Read article