Generate Formulas in Google Sheets

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

Enter your problem
Describe the range
Get 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.

Google Sheets Tools

Discover best addons for google sheets, and betters ways to use Google Sheets. Create. Style. Sell. Automate.

Formula Generator Freemium

Create a formula for any reason or no reason. Try it out free.

Sparkline Generator Freemium

Create a tiny chart in your Google Sheets with =SPARKLINE().

RegexMatcher Freemium

Create formulas with regular expressions to match patterns.

RegexReplacer Freemium

Create formulas with regular expressions to replace text patterns.

Conditional Formatter Freemium

Create custom formulas for conditional formatting.

Create Copy URL Free

Create a copy url to easily copy a Google Sheet.

Sheet to PDF Free

Create a PDF url for your Google Sheets.

Sheet to CSV Free

Create a CSV url for your Google Sheets.

Embed Sheets 2 Site Free

Create a native embed code for your website.

SheetShot Free

Generate a high resolution screenshot your Google Sheet. Great for use on mobile.

OnlySheets Paid

Add a simple paywall your Google Sheets. Never lose a sale again.

Daily Tracker Free

Track habits, chores, or tasks with this free daily tracker.

Atomic Sheets Paid

100 unique Google Sheets elements. Pixel art you can use instantly.

Tiny Sheets Free

Delete unnecessary rows and columns in one click.

Sheet Styles Free

Add custom styles to your Google Sheets.

Button Styles Free

Add custom buttons to your Google Sheets.

Spintax Free

Parse Spintax inside your Google Sheets.

Discover More Tools >>>

Join over 5,000 satisfied users and unlock more tools for your Google Sheets.