# How to use sumif function in excel with example

July 26, 2022
1.3K Views
0

A free Office suite fully compatible with Microsoft Office

A free Office suite fully compatible with Microsoft Office

Excel's robust SUMIF function allows you to sum cells according to a single criterion. There are a tonne of simple SUMIF examples on this page.

How to use SUNIF function in excel online, 2016 and 2019:

To sum cells depending on integers that fulfil specified criteria, use Excel's SUMIF function.

Values in the range A1:A5 that are less than or equal to 10 are added together using the SUMIF function (two arguments) below.

The SUMIF function that follows yields the same outcome. The less than or equal to sign and the value in cell C1 are joined by the & operator.

If the matching cells in the range A1:A5 contain the value 25, the SUMIF function below (three parameters, last argument is the range to sum) sums the values in the range B1:B5.

The SUMIF function that follows yields the same outcome (second argument refers to cell D1).

Text criteria in excel:To sum cells based on text strings that fulfil particular requirements, use Excel's SUMIF function. Text should always be encased in double quotation marks.If the corresponding cells in the range A1:A5 contain exactly circle, the SUMIF function below adds the values in the range B1:B5.

If the associated cells in the range A1:A5 do not comprise an exact triangle, the SUMIF function below sums the values in the range B1:B5.

If the matching cells in the range A1:A5 contain exactly circle + 1 character, the SUMIF function below adds the values in the range B1:B5. A question mark (?) corresponds to one single character.

If the matching cells in the range A1:A5 contain a series of zero or more characters + le, the SUMIF function below adds the values in the range B1:B5. A series of zero or more characters is indicated by an asterisk (*).

If the matching cells in the range A1:A5 contain exactly triangles or circles8, the SUMIF methods below will sum the values in the range B1:B5.

Date criteria in excel:To sum cells depending on dates that fulfil specified criteria, use Excel's SUMIF function.The sales after January 20, 2018, are totaled using the SUMIF method below.

It should be noted that Excel's DATE function takes three arguments: year, month, and day.Today's sales are totaled by the SUMIF function below.

Lets support today is August 3rd,2018.The sales between two dates are added together using the SUMIFS function (with a S at the end).

When used in Excel, the SUMIFS function adds cells based on two or more criteria (the range to sum is the first parameter, followed by one or more range/criteria pairs). To add the sales for a particular month, year, etc., change the dates.Note: This above written article is an attempt to show you how to use SUMIF function in excel online, 2016 and 2019, in both windows and mac.You just need to have a little understanding of how and which way things work. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.