# Google Sheets Formulas List: 25 Essential Functions for 2024

Google Sheets is a powerful tool for data analysis, and understanding its key formulas can significantly enhance your productivity.

Here are 25 essential formulas that cover a wide range of functionalities, from basic arithmetic to complex data manipulation.

### 1. SUM

Adds up a range of cells.

=SUM(A1:A10)

### 2. AVERAGE

Calculates the average of a range of cells.

=AVERAGE(B1:B10)

### 3. COUNT

Counts the number of cells in a range that contain numbers.

=COUNT(C1:C10)

### 4. MIN

Returns the smallest number in a set of values.

=MIN(D1:D10)

### 5. MAX

Returns the largest number in a set of values.

=MAX(E1:E10)

### 6. IF

Performs a conditional test and returns one value if true and another if false.

=IF(F1>10, "Yes", "No")

### 7. VLOOKUP

Searches for a value in the first column of a range and returns a value in the same row from a specified column.

=VLOOKUP("Apple", A1:B10, 2, FALSE)

### 8. HLOOKUP

Searches for a value in the top row of a table or range and returns a value in the same column from a specified row.

=HLOOKUP("Jan", A1:D4, 2, FALSE)

### 9. INDEX

Returns the value of a cell in a specific row and column of a range.

=INDEX(A1:C10, 2, 3)

### 10. MATCH

Searches for a specified item in a range of cells, and then returns the relative position of that item.

=MATCH("Banana", A1:A10, 0)

### 11. COUNTIF

Counts the number of cells within a range that meet a single condition.

=COUNTIF(A1:A10, ">20")

### 12. SUMIF

Adds all numbers in a range of cells based on one criterion.

=SUMIF(B1:B10, ">5", B1:B10)

### 13. AVERAGEIF

Calculates the average of a range depending on a criterion.

=AVERAGEIF(C1:C10, "<>10", C1:C10)

### 14. CONCATENATE (or CONCAT/JOIN)

Joins together text strings into one text string.

=CONCATENATE("Hello", " ", "World")

### 15. LEFT

Returns the first character(s) in a text string based on the number of characters specified.

### 16. RIGHT

Returns the last character(s) in a text string based on the number of characters specified.

### 17. MID

Returns a specific number of characters from a text string starting at the position you specify.

### 18. LEN

Returns the length of a text string in terms of characters.

### 19. SEARCH

Finds one text string within another text string and returns the position of the first occurrence.

### 20. TRIM

Removes extra spaces from text except for single spaces between words.

### 21. LOWER

Converts text to all lowercase letters.

### 22. UPPER

Converts text to all uppercase letters.

### 23. PROPER

Converts text to title case, the first letter in each word to uppercase, and the rest to lowercase.

### 24. NOW

Returns the current date and time.

=NOW()

### 25. DATE

Converts a year, month, and day into a date.

=DATE(2024, 2, 10)

We hope that this Google Sheets formulas list has helped you and given you a better understanding of the essential functions of Google Sheets. If you enjoyed this article, you might also like our articles on how to remove conditional formatting in Google Sheets and how to convert CSV to Google Sheets.

# Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
Creates a one- or multiple-day calendar event with optional attendees
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL