Tutorials
Search... Practice
Sign In
Jobs
ut Keys Data Analysis in Excel Formatting Workbooks Statistical Functions Data Visualization in Excel Pivot Tables in Excel
Basic Excel Formulas
Last Updated : 22 May, 2026
MS Excel helps you perform calculations quickly and accurately using built-in formulas. By
learning basic Excel formulas, you can easily add numbers, find averages, identify maximum and
minimum values, and analyze data efficiently in everyday tasks.
Foundational Excel Formulas
1. Sum Function
The SUM function adds all numeric values in a selected range. It’s commonly used to calculate
totals.
Syntax: =SUM(number1, [number2], ...)
New Google New Google
AI Certificate AI Certificate
Enroll in the new Google AI Enroll in the new Google AI
Professional Certificate today. Professional Certificate today.
Coursera Coursera
Where:
number1, [number2], are the numbers, cell references (e.g., C3:C8), or ranges to add together.
Use this to calculate the total of values, like summing vegetable costs in C3:C8
2. Max Function
The MAX function returns the highest value from a range, helping identify peak expenses.
Syntax: =MAX(number1, [number2], ...)
Where:
number1, [number2], are the numbers or range (e.g., C5:C12) to evaluate. Apply this to find the
highest value, such as the most expensive item in a list.
3. Min Function
The MIN function finds the lowest value in a range, useful for spotting minimum costs.
Syntax: =MIN(number1, [number2], ...)
Where:
number1, [number2], are the numbers or range (e.g., C5:C10) to evaluate. Use this to determine
the lowest value, like the cheapest vegetable.
4. Average Function
The AVERAGE function calculates the mean of a range of values, giving insight into typical
spending.
Syntax: =AVERAGE(number1, [number2], ...)
Where:
number1, [number2],are the numbers or range (e.g., C5:C10) to average. Employ this to find the
mean value, such as the average cost of items.
5. Count Function
The COUNT function counts how many cells in a range contain numeric values.
Syntax: =COUNT(number1, [number2], ...)
Where:
number1, [number2], are the numbers or range (e.g., C5:C10) to count.
6. Len Function
The LEN function returns the number of characters in a text string. It’s useful for data validation
and text analysis.
Syntax: =LEN(text)
Where:
Text is a cell reference (e.g., A5) containing the text string to measure. Apply this to count
characters, like the length of "brinjal".
7. SUMIF Function
The SUMIF function adds values that meet a specific condition.
Syntax: =SUMIF(range, criteria, [sum_range])
Where:
Range is the cells to check (e.g., C5:C10), criteria is the condition (e.g., ">20"), and [sum_range]
(optional) is the cells to sum if different from range. Use this to add values meeting a condition,
like costs over 20.
8. AVERAGEIF Function
The AVERAGEIF function calculates the average of values that satisfy a condition.
Syntax: =AVERAGEIF(range, criteria, [average_range])
Where:
Range is the cells to check (e.g., C5:C10), criteria is the condition (e.g., ">20"), and
[average_range] (optional) is the cells to average if different from range. Apply this to average
values meeting a condition, like costs above 20.
Suggested Quiz 5 Questions
What is the primary purpose of the SUM function in Excel?
A To find the highest value
B To add numeric values in a range
C To calculate the average
D To count numeric cells
Login to View Explanation 1/5 < Previous Next >
Comment D divyan… 26
Article Tags: Excel ExcelGuide MSExcel
Company Explore Tutorials Courses Preparation
About Us POTD Programming ML and Data Corner
Corporate & Communications Address: Legal Practice Languages Science Interview
Privacy Problems DSA DSA and Corner
A-143, 7th Floor, Sovereign Corporate
Tower, Sector- 136, Noida, Uttar Policy Connect Web Placements Aptitude
Pradesh (201305) Careers Blogs Technology Web Puzzles
Contact Us Upskill AI, ML & Development GfG 160
Registered Address:
Corporate Courses Data Science Data Science System Design
K 061, Tower K, Gulshan Vivante Solution DevOps Programming
Apartment, Sector 137, Noida, Gautam
Campus CS Core Languages
Buddh Nagar, Uttar Pradesh, 201305
Training Subjects DevOps &
Program GATE Cloud
School GATE
Subjects MongoDB
Software and Certifications
Tools
@GeeksforGeeks, Sanchhaya Education Private Limited, All rights reserved