# Google Sheets Formulas List: 25 Essential Functions for 2024

May 8, 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.

Get Google Sheets productivity and automation tips delivered straight to your inbox