Griddy / Blog
Spreadsheet how-tos.
Step-by-step guides for Excel and Google Sheets formulas, data cleanup, charts, and more — and how Griddy handles each one in seconds.
Page 1 of 2 · 20 posts
How to Use SUMIF in Excel
SUMIF adds up values in a range that meet a single condition. Here's the syntax, practical examples, and common mistakes — including when to upgrade to SUMIFS.
How to Use COUNTIF in Excel
COUNTIF counts cells in a range that meet a condition — text, numbers, dates, or wildcards. Here's the syntax, examples for common use cases, and when to use COUNTIFS instead.
Google Sheets SUMIF with Multiple Criteria
SUMIF only handles one condition. When you need to sum by multiple criteria in Google Sheets, use SUMIFS — or SUMPRODUCT for more flexibility. Here's exactly how.
How to Freeze Panes in Excel
Freeze rows and columns in Excel so your headers stay visible as you scroll. Step-by-step for freezing the top row, first column, or any custom split — and how to unfreeze.
How to Concatenate in Excel (Join Text from Multiple Cells)
Three ways to combine text from multiple cells in Excel: the & operator, CONCAT, and TEXTJOIN — with examples for names, addresses, and delimited lists.
Excel IF Statement with Multiple Conditions
How to write Excel IF formulas that check more than one condition using AND, OR, and nested IFs — with practical examples for each.
Excel INDEX MATCH: The Better Alternative to VLOOKUP
INDEX MATCH can look up values in any direction, never breaks when you insert columns, and handles multiple conditions. Here's how it works and when to use it over VLOOKUP.
How to Use XLOOKUP in Excel
XLOOKUP is the modern replacement for VLOOKUP — it can look in any direction, handles missing values cleanly, and doesn't break when columns shift. Here's how it works.
How to Remove Duplicates in Excel
Three ways to find and remove duplicate rows in Excel: the built-in tool, COUNTIF to flag them first, and UNIQUE for a clean deduplicated list. Plus what to do when duplicates are hiding.
How to Sort Data in Excel
Sort Excel data alphabetically, numerically, by multiple columns, or by custom order. Covers the Sort button, the SORT function, and how to avoid the most common sorting mistake.
How to Fix the VLOOKUP #N/A Error in Excel
The #N/A error in VLOOKUP means the lookup value wasn't found. Here are the six most common reasons and exactly how to fix each one.
How to Make a Pivot Table in Excel
Pivot tables let you summarize thousands of rows into a clean report in seconds. Here's how to build one from scratch, customize it, and avoid the most common mistakes.