All resources related to SUMIF for Excel and Google Sheets.

All articles
SUMIF

How to sum up if greater than or less than 0 – Excelchat

We can sum a data set with a specified criterion using the SUMIF function. The criteria could be for values to sum if greater than or sum if less than a number. This tutorial would teach us how to sum values if they are greater than or less than a...

Using the SUMIF Function to Add Cells if They Contain Certain Text

With the help of SUMIF Function, we can also add cells that contain specific or partial text and even if the cells contain numbers and text altogether, they can also be added. Let’s have a look on how is it done with a slight change in the formula Using SUMIF...

Working with the SUMIF Function and Two Conditions

SUMIF: SUMIF is a function in Excel used to add all the numbers in a range based on one criteria/condition. In case of two or more criteria’s/conditions, the formula used is: Formula: =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2]) SUMIF Function in Excel can be used in two ways: By putting SUMIF...

Comparing the Lookup Functions of SUMIF vs INDEX vs MATCH in Excel

There are several functions in Excel that are useful in finding a given value in a range of cells, such as the SUMIF, INDEX and MATCH functions. This step by step tutorial will assist all levels of Excel users in comparing the lookup functions of SUMIF, INDEX and MATCH. ...

What is the Difference Between SUMIF vs. SUMIFS vs. SUMFPRODUCT?

Excel has some of the most powerful functions for us in order to make our work much easier. Functions under discussion are considered as advanced excel functions. In this tutorial, we will learn the difference between the following functions as follow: SUMIF SUMIFS SUMPRODUCT SUMIF SUMIF function help...

Using SUMIF to Add Cells If They Contain Certain Text

While working with Excel, we are able to sum values that satisfy a given criteria by using the SUMIF function. This step by step tutorial will assist all levels of Excel users in summing values that may contain certain text. Figure 1. Final result: Using SUMIF to add cells...

How to Use SUMIF to Sum Cells Based on Background Color

While working with Excel, we are able to sum values that satisfy a given criteria by using the SUMIF function. This step by step tutorial will assist all levels of Excel users in summing values in cells based on background color. Figure 1. Final result: Using SUMIF to sum...

Tips on How to Sum Time in Excel

Time value is stored as a serial number in Excel and sometimes it is tricky to get the accurate result while adding time values in Excel. We need to make sure to use the right approach while making calculations to get an accurate sum of time values. In this article,...

How to Apply the SUMIF Function to Negative Criteria

We sum the values using the SUMIF function where cell value is equal to the criteria value. However, we can also sum the values where cell isn’t equal to the criteria value. This step by step tutorial will help all levels of Excel users learn how to use the SUMIF...

How to Use the SUMIF Function Across Multiple Sheets

When the data is spread out in different worksheets in similar ranges of cells, we can add categorize the data by using the SUMIF function across multiple sheets. This can be done by nesting the SUMIF function and the INDIRECT function. This step by step tutorial will assist all levels...