SUMIF Articles: Excel and Google Sheets

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...

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...

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...

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.  ...

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...

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...

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...

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,...

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...

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...