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])
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.
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.
And the Result is
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 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.