QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to SUMIF in Excel?

By Neha T Leave a Comment

SUMIF is one of the useful function in excel. This function returns the total sum of the specified range when the specified criteria is met by the specified range. SUMIF function ease our work if we are in search of the sum, based on the criteria.

The syntax of the SUMIF function is as follow:

= SUMIF(range, criteria,[sum_range])

The range is the range of cells which has to be evaluated against the specified criteria.

The criteria is the condition which is evaluated against the range specified. Criteria can be a number, text, function or a cell reference.

The sum_range is the range of cells whose values are to be actually added.

Note: SUMIF is not case sensitive. If the ‘sum_range’ is not specified in the formula, it returns sum of values in ‘range’.

In this section, we will explore the working of SUMIF functions. So let us start.

Steps to SUMIF in Excel 2016:

Basic Use

The basic task of the SUMIF function is to return the sum of the values in the range specified by us if they meet the criteria specified by us.

Let us see an example below:

Sumif basic use 1

Here, the SUMIF function returns the sum of all the values present in the range C3:C15 and are “>200”.

Utilizing the SUMIF function fully, the example below shows the sum of the number of days where sales are greater than 200.

Sumif basic use 2

SUMIF with Criteria in Another Cell

While using SUMIF if you want to include the value present in another cell as, criteria you can do it with the help of concatenation. Like in the example below, while using SUMIF I have concatenated “>” with the cell E9 using ‘&’. SUMIF function here, return the sum of the number of days where sales are greater than the value present in E9.

Sumif with criteria in another cell

SUMIF with Date Criteria

You can also include a date in the criteria section of the SUMIF function. The example below shows the sum of all the number of sales which are done after the date 16-02-2020.

Sumif with date criteria-1

The example below shows the sum of the number of sales done today.

Sumif with date criteria-2

SUMIF with Not Equal to Criteria

To mention, ‘not equal’ to in the criteria section you have to use ‘<>’ operator. The example below shows the sum of the number of days where the number of sales is not equal to 100.

Sumif with not equal to criteria

SUMIF with Wildcard

SUMIF function allows you to use wildcards in the criteria section. Like the below example shows the sum of the number of sales done by the staff whose name has exactly four characters.

Sumif with wildcards

The example below shows the sum of the number of sales done by the staff whose names are starting with the alphabet ‘J’.

Sumif with wildcards -1

The example below shows the sum of the number of sales done by the staff whose names are ending with ‘a’.

Sumif with wildcards -2

So, this is all about the SUMIF function in excel. We have explored the function in various method but it’s not all, you can explore it to find more. Hope the content is useful. Keep reading.

You Might Also Like:

generate a random number in excel featured imageHow to Generate Random Number in Excel? Create a named range in Excel feature imageHow to Create Named Range in Excel? feature imageHow to COUNTIF in MS Excel 2016? How to Concatenate in Excel -featured imageHow to Concatenate Multiple Cells in MS Excel 2016? How to add in Excel-featured imageHow to Add or Sum in MS Excel 2016? count unique values featured imageHow to Count Unique Values in Excel 2016? Change Date Format featured imageHow to Change the Date Format in Excel? Delete Duplicates feature imageHow to Delete Duplicates in Excel 2016?

Leave a Reply Cancel reply

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

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Add Read More Button in WordPress
  • How to Configure your Default Application in Ubuntu 14.04
  • How to Tag Someone on Instagram Post?
  • How to Edit the Copyright Footer in Joomla in 3.x
  • How to Change Login Screen Background in Windows 10?

Copyright © 2023 · QueHow · Contact Us