Watch Excel Tutorial Video – Excel Function – SUMIF

How to use SUMIF function in Excel?

Complete Excel VBA Course

SUMIF function is used to get the “total sum” of values for matching criteria across range.

SUMIF Function has two required arguments i.e. rangecriteria and optional argument i.e. [sum_range].

Kindly note, [sum_range] is optional ONLY in-case where criteria and [sum_range] are in ONE column, but if, criteria and [sum_range] are in DIFFERENT columns then [sum_range] is NOT optional

Complete Excel VBA Course
=SUMIF(range, criteria, [sum_range])
Syntax Description:

range argument is used to give the range of cells in which criteria needs to find,

criteria argument is used to give criteria for sum. We can give value (example “A”,”A*” >10, 50 ) or cell reference# (example: E2) in this argument,

sum_range argument is used to give cell range; those are to be added together as per the criteria mentioned above

Example 1: SUMIF function with various criteria:

Here, we have sales for various Locations and want to get the total sales as per the criteria given in function:
  • “Column A to B” has sales details,
  • “Column D” shows the sample criteria, that is applied,
  • “Column E” shows the sample formula applied,
  • “Column F” shows the output of the function and,
  • Explanation is provided in Columns “G & H”

We will be using SUMIF function as follows:

SUMIF Function
Things to Remember:

– Criteria argument can also work with Wild characters i.e. asterisk (*), question mark (?). Asterisk will find any series of characters and Question mark will find a single character.

– If you want to search actual * or ? (Asterisk or Question Mark) then type tilde (~) before * or ?

Hope you learnt this Function,

Don’t forget to leave your valuable comments!

Recommended Articles

Secrets of Excel Data Visualization: Beginners to Advanced Course

Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.

This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.

So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.

Excel VBA Course : Beginners to Advanced

We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion

This course is going to help you to excel your skills in Excel VBA with our real time case studies.

Lets get connected and start learning now. Click here to Enroll.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *