In this article:

Google Sheets Formulas List: 25 Essential Functions for 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.

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
When a new row is added to Google Sheets
On new Google Form submission
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
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
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
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started