In this article:

Google Sheets Formulas List: 25 Essential Functions for 2024

May 8, 2024

Google Sheets Formulas List

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.

google sheets formulas list
Source: thenextweb.com

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.

=LEFT("Google Sheets", 6)

16. RIGHT

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

=RIGHT("Google Sheets", 6)

17. MID

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

=MID("Google Sheets", 8, 6)

18. LEN

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

=LEN("Google")

19. SEARCH

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

=SEARCH("Sheets", "Google Sheets")

20. TRIM

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

=TRIM("   Google Sheets   ")

21. LOWER

Converts text to all lowercase letters.

=LOWER("GOOGLE SHEETS")

22. UPPER

Converts text to all uppercase letters.

=UPPER("google sheets")

23. PROPER

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

=PROPER("google sheets")

24. NOW

Returns the current date and time.

=NOW()

25. DATE

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

=DATE(2024, 2, 10)

google sheets functions list
Source: blog.golayer.io 

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
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->