How to Use COUNTIF in Google Sheets (2026 Guide)
Use COUNTIF in Google Sheets to count cells by condition: text, numbers, wildcards, and dates, plus COUNTIFS for multiple criteria, with copy-paste examples.
Formulas
11 posts
How to Use SUMIF in Google Sheets (2026 Guide)
Use SUMIF in Google Sheets to total cells by condition: text, numbers, wildcards, and dates, plus SUMIFS for multiple criteria and the most common errors.
How to Concatenate in Excel (Combine Text from Cells, 2026)
Combine text from multiple cells in Excel: the & operator, the CONCAT and TEXTJOIN functions, adding spaces and commas, and joining a whole range with a delimiter.
How to Use INDEX MATCH in Excel (with Examples, 2026)
Learn INDEX MATCH in Excel: how the two functions work together, why it beats VLOOKUP, looking left, a two-way lookup with two MATCH functions, and error fixes.
How to Use SUMIF in Excel (with Examples, 2026)
Learn SUMIF in Excel: the syntax, text and number criteria, comparison operators, wildcards, summing a different column, and SUMIFS for multiple conditions.
How to Use the IF Function in Excel (with Examples, 2026)
Learn the IF function in Excel: the syntax, text and number tests, nested IFs, the IFS function, combining IF with AND and OR, and how to fix common errors.
How to Use VLOOKUP in Excel (with Examples, 2026)
Learn VLOOKUP in Excel step by step: the syntax, exact vs. approximate match, looking up data from another sheet, anchoring the range, and how to fix #N/A and #REF errors.
How to Use XLOOKUP in Excel (with Examples, 2026)
Learn XLOOKUP in Excel: the syntax, exact and approximate match, looking left, returning multiple columns, the built-in if_not_found argument, and how it beats VLOOKUP.
How to Use the IF Function in Google Sheets (with Examples, 2026)
Master the IF function in Google Sheets: the syntax, nested IFs, IFS for multiple conditions, and combining IF with AND, OR, and ISBLANK — with copy-paste examples.
How to Use the QUERY Function in Google Sheets (with Examples, 2026)
Use the QUERY function in Google Sheets to filter, sort, and summarize data with SQL-like syntax: SELECT, WHERE, ORDER BY, GROUP BY, LABEL, and pulling from another sheet.
How to Use VLOOKUP in Google Sheets (with Examples, 2026)
Learn VLOOKUP in Google Sheets step by step: the syntax, exact vs. approximate match, looking up data from another sheet, and how to fix #N/A and #REF errors.