Google Sheets Formula List: Essential Functions and Examples

What is a Google Sheets formula list and why you need it

A Google Sheets formula list is a curated collection of built‑in functions you can apply to cells to perform calculations, transform data, and automate workflows. It helps standardize patterns, reduces errors, and accelerates analysis across projects. According to How To Sheets, a well‑organized formula list provides a reliable toolkit you can reuse in new sheets without reinventing the wheel. This section starts with a quick tour of the most common categories and demonstrates practical examples to illustrate how a list is used in real work.

In addition to math, you’ll rely on logical and comparison functions like:

As you expand your list, you’ll group formulas by purpose: math and statistics, text manipulation, date/time, lookups, and array/dynamic formulas. This structure makes it easier to reuse patterns across multiple sheets and projects. The goal is to build mental muscle around formula templates and then swap references as your data evolves.

Core formulas every Google Sheets user should know

Whether you’re a student, professional, or small business owner, a solid core of formulas unlocks most daily tasks in Sheets. Start with sums and averages to quantify data, then layer in logic to handle conditions, and finally bring in lookups to merge data across ranges. The following examples demonstrate typical patterns you’ll reuse frequently in budgets, inventories, and reports.

In more advanced use, combine criteria with ranges:

Containerized logic helps you pre‑build templates that your teammates can adapt, preserving consistency across projects while saving time on repetitive tasks.

Text manipulation and data cleaning formulas

Text handling is essential for preparing data from various sources. Clean, join, split, and extract substrings with purpose‑built text formulas. Start by concatenating fields for readable labels, then trim spaces and remove non‑printable characters. Patterns like TEXTJOIN with a delimiter are invaluable when you need to assemble lists, titles, or notes from multiple cells.

For consistency, consider trimming and cleaning values before processing:

These techniques help maintain clean datasets that feed reliable reports and dashboards.

Lookup and reference formulas

Joining data across sheets or tables is a foundational skill. VLOOKUP fetches matching values from a table, while INDEX/MATCH offers more flexibility and avoids some VLOOKUP limitations. Google Sheets also provides XLOOKUP for a modern, readable alternative. Practice with a small reference table to reinforce correct range anchoring and error handling.

When you work across sheets, prefix with the sheet name:

INDEX/MATCH combinations are often preferred for large data sets in Sheets.

Date and time formulas

Dates and times underpin almost every project in Sheets, from deadlines to financial periods. TODAY and NOW give current date/time, while EDATE and EOMONTH help you calculate future or past periods. NETWORKDAYS can be used to count working days between two dates, excluding weekends and holidays. Build calendars, milestones, and schedules with confidence.

For holiday-aware calculations, add a range of holiday dates as a third parameter when using NETWORKDAYS.

Array formulas and dynamic functions

Array formulas enable column‑wide calculations without copying formulas down a whole column. They are especially powerful when data grows, or when you want to apply logic across multiple rows in one go. Combined with FILTER, UNIQUE, SORT, and QUERY, you can build compact, scalable data pipelines inside Sheets.

Advanced users also leverage QUERY for SQL‑like data extraction:

Array handling must be tested for performance on very large sheets, but provides dramatic productivity gains when used thoughtfully.

Practical example: building a formula-driven mini-dashboard

To demonstrate how a formula list scales, this final section builds a tiny dashboard that summarizes sales by category, using a mix of the functions covered above. You’ll assemble a header row, apply SUMIF for category totals, and then pull a compact summary with QUERY. The goal is to show how a consistent formula list translates into an actionable, readable dashboard you can extend.

This example demonstrates how common patterns—sums by category, by region, or by product—can be assembled into a single, reusable template. As your data evolves, you can swap out ranges or criteria without rewriting the core logic.

Wrap-up: building a personal library of formulas

The final takeaway is to codify your most-used patterns into a personal formula library. By aligning sections of math, text, date/time, lookup, and array logic, you create a mental map that speeds up analysis and reduces errors. Start by cataloging ten go-to formulas, then add 2–3 new templates each week. Over time, your Google Sheets proficiency will compound, and your work will become more scalable and reliable.