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 5 of 7 · 76 posts
How to Use VLOOKUP in Google Sheets
VLOOKUP in Google Sheets searches the first column of a range and returns a value from another column. Here's the syntax, exact-match examples, common errors, and when to use XLOOKUP instead.
How to Build a Freelancer Invoice Workflow in Excel
A freelancer invoice workflow is more than one invoice file. Here's how to set up a simple spreadsheet system for billing, due dates, payments, and expense context.
How to Track Small Business Expenses in a Spreadsheet
A small business expense sheet should do more than log transactions. Here's how to structure categories, receipts, and rollups so the spreadsheet is actually useful.
How to Use IFERROR in Excel
IFERROR replaces ugly spreadsheet errors with a cleaner fallback. Here's the syntax, the most common use cases, and when to avoid hiding real problems.
XLOOKUP vs VLOOKUP: Which Should You Use?
VLOOKUP is older and widely compatible. XLOOKUP is cleaner and more flexible. Here's when each one makes sense and how to choose between them.
Budget Tracker vs Expense Tracker: What's the Difference?
A budget tracker helps you plan spending before it happens. An expense tracker records what already happened. Here's when to use each one and when you need both.
How to Use COUNTIFS in Excel
COUNTIFS counts rows that match multiple conditions. Here's the syntax, examples for text, dates, blanks, and thresholds, plus the mistakes that break the count.
How to Use SUMIFS in Excel
SUMIFS adds values that meet multiple conditions. Here's the syntax, exact examples for text, dates, and thresholds, plus the mistakes that cause wrong totals.
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.
COUNTIF in Excel: Formula Examples for Budgets, Status, and Duplicates
Use COUNTIF in Excel to count rows by category, status, threshold, duplicate value, or wildcard match. Includes practical formulas and fixes.
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.