List of common Excel formulas with examples

Here’s a list of common Excel formulas with examples:

  1. SUM: Adds up a range of cells. Example: =SUM(A1:A5)
  2. AVERAGE: Calculates the average of a range of cells. Example: =AVERAGE(B1:B5)
  3. COUNT: Counts the number of cells in a range that contain numbers. Example: =COUNT(A1:A5)
  4. MAX: Returns the largest value in a range of cells. Example: =MAX(B1:B5)
  5. MIN: Returns the smallest value in a range of cells. Example: =MIN(B1:B5)
  6. IF: Returns one value if a condition is true and another value if it’s false. Example: =IF(A1>10, "Greater than 10", "Less than or equal to 10")
  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. Example: =VLOOKUP(A1,B1:C5,2,TRUE)
  8. INDEX: Returns the value of a cell in a specified row and column of a range. Example: =INDEX(B1:C5, 2, 2)
  9. MATCH: Searches for a value in a range and returns the relative position of the value within the range. Example: =MATCH(A1,B1:B5,0)
  10. CONCATENATE: Joins two or more values together into a single text string. Example: =CONCATENATE(A1," ",B1)

These are just a few of the most commonly used Excel formulas. There are many others available to perform a wide range of calculations and manipulations in your spreadsheets.


Gavesh S. is the founder and owner of He has been a Microsoft Excel Expert since early 2012. With experience explained thousand of queries for companies including Microsoft and top other financial institutions. Theres is most uses of Business Analysis, People Management, Automation, Performance Reporting, Strategic Analysis, Project Management, Managing Programs, Account Management etc.  In 2021 he found to share his experiences with other who’s is looking to learn MS Excel. He is currently working on a book about working in the Learn Excel, expanding his skill set beyond the Excel Learning niche.