5 Must-Know Excel Formulas: SUM, INDEX, MATCH, SUMIF, SUMIFS

One of the most basic functions in Excel is summing data, looking up values, and matching them to other cells. In this Excel tutorial, we're going to walk you through the basics of the SUM, INDEX, MATCH, SUMIF, and SUMIFS formulas.

Identifying values that match your criteria and can be a burdensome process if done manually and with large sets of data. By the end of this video, you'll learn 5 of the most prevalent formulas that can help you find key data points among a sea of your data.

Watch the video and follow as the steps are written below 👇

SUM Function - This will add all the highlighted cells.

🧪 =SUM(Highlight Cell Range)

INDEX Function

🧪 =INDEX(reference, row_num, [column_num], [area number])

MATCH Function

🧪 =MATCH(lookup_value, lookup_array, [match_type])

SUMIF Function

🧪 =SUMIF(range, criteria, [sum_range])

SUMIFS Function

🧪 = SDUMIFS(sum_range,critria_range1,critria1,critria_range2,critria2,...)

Want to download amazing Excel templates? Try 5 templates for FREE! 😎

00:00 Introduction
00:39 SUM Function
00:53 INDEX Function
1:34 MATCH Function
1:56 SUMIF Function
2:30 SUMIFS Function
3:20 Apply SUMIFS(INDEX(MATCH function together

#excelformula #exceltips #excelfunctions

...

GET ACCESS TO 100+ Dynamic Excel Spreadsheet Templates

Project Management 📰
Marketing 📊
Supply Chain and Operations 🚚
Small Business 🦾
Human Resources 👨🏾‍🤝‍👨🏼
Data Analysis 👨‍🔬
Accounting 🧐
Finance 💵

These templates empower you to use Excel to streamline all your personal and business needs.

🦄 Customizable
🧨 Dynamic
🎨 Designed
🏭 Formatted
👩‍🏫 Instructions and Videos
📈 Reporting Visuals

Get 5 FREE Templates When You Sign Up 👇

Want to 🔐 new skills that improve your income, marketability, and expertise?

Our Excel University has 48+ lectures to help you master Microsoft Excel.

We'll walk you through everything you need to know to be an Excel Expert 🏆

🔎 Lookups
🔨 Functions
🧪 Formulas
📊 Charts and Graphs
🔢 Dashboards

♪ Break up (Prod. by Lukrembo)
Link :

• (no copyright mus...

[martinmaison]

Very useful

=SUMIFS(INDEX(entire table, , MATCH(sum results column heading name, entire Heading column )), criteria 1 vertical column, target criteria, criteria 2 vertical column, target criteria, 3 vertical column, target criteria, 4 vertical column, target criteria)

[notanaive]

Thank you so much but the background music doesn't allow to hear you well and be concentrated.

[AdrienneDiRosario]

Using music with words makes it impossible to understand what you're saying

[hamzasenhaji]

not very well explicated and you go so fast that we can't follow.