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

Explain as much or as little as you'd like


Defaults to A1 if left blank


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.