|Connect us with

SUMIF Function In Excel

SUMIF In Excel | SUMIF Syntax | How to Use

Note:-Before starting any Formula or Function you need to add (=)

SUMIF is the function that is used to calculate a sum of values in a range that satisfies a specific condition you specify instead of calculating the sum of an entire range.

In other words, it is the combination of SUM and IF function. it adds all numbers in a range of cells based on criteria. Learn how to use the SUMIF function here.

Syntax:-=SUMIF(range, criteria, [sum_range])

How to Use SUMIF Function in Excel?

SUMIF Function in Excel

In the above example, we have multiple cities in the city column. and we want to get the total value of the Karnataka city in G2 Cell. but to get the total value of Karnataka city we can use individual cell addition. but it is a time-consuming process.

SUMIF Function in Excel

In this type of situation, we can use the SUMIF Function.here it calculates a sum of values in a range with city name condition.

SUMIF Function in Excel

And the Result is

SUMIF Function in Excel

After watching the video you can download below sample sheet and it helps you to do practice more. please subscribe for more videos on our youtube channel. if you like our tutorial please share it on Facebook and Youtube below.

To Get FREE Excel Shortcut Keys





Why basictutorials.in ?

● To Learn Tutorials in a Simple Way.

● To Learn Excel Basics With Downloadable Samples.

● To Learn HTML With Sample Website Code.

● To Learn PowerPoint Presentations.

● To Learn MS Word for Offical use.