Generate Formulas in Google Sheets

Creates a Google Sheets formula for any use case you can imagine.

Enter your problem
Describe the range
Generate your formula

Formula Examples

Write formulas in Google Sheets easily

SUMIF()

Sum Based on Value

I want to lookup in column A for the value "John" and return the value in column B all summed up

AVERAGE()

Get Average

I want to get the average of the cells in column A.

MAX()

Highest Number

Can you show which number is highest in column C?

SUM()

Add Up

How to sum a column in google sheets. I want to add up all the values when they are actaully numbers. Not when the cell is text.

Formula Directory

Google Sheets Formula List with video examples of each formula as it's used in Google sheets.

Learn how to use each Google sheets formula. Watch a video example of each formula in action. See formula combinations in action like INDEX/MATCH, IF/ISBLANK. Watch as hard to understand formulas are used with ease in complex situations to solve hard problems.

Unlock the potential of VLOOKUP - A dynamic formula perfect for creating summaries and managing inventory.
Discover the versatility of SUMIF - Ideal for filtering data and calculating totals based on specific criteria.
Dive into advanced formulas like COUNTIF and IFS - Build skills in data manipulation and analysis.

Explore the Formula Directory