All resources related to SUMIF for Excel and Google Sheets.

How to Use the SUMIF and OR Functions Together

The SUMIF function in Excel is used to sum values based on a single condition or criteria. However, if we want to sum values based on multiple criteria where at least one of the conditions are met, we use the SUMIF with OR logic. There are different methods to do...

Comparing SUMIF vs COUNTIF vs AVERAGEIFS to Deal with Multiple Criteria

Excel can calculate a sum, average or count of values based on specific criteria by using the SUMIFS, COUNTIFS and AVERAGEIFS functions. This step by step tutorial will assist all levels of Excel users in comparing these functions to deal with multiple criteria. Figure 1. Final result Syntax of the...

Using the SUMIF Function for Adding Between Two Values

We often need to sum values from a table based on a certain condition. The SUMIFS function is the perfect solution for this problem. In this tutorial, we will step through how to sum values based on a specific condition. Figure 1. Final result Syntax of the SUMIFS formula =SUMIFS(sum_range,...

Using SUMIF to Add Values Within a Date Range

While working in Excel, we often need to sum values from a table based on a certain condition. In this tutorial, we will learn how to sum values with specific conditions using the SUMIFS function. Figure 1. Final result Syntax of the SUMIFS formula =SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2) The...

A Guide on Using SUMIF with the Time Format

The SUMIF function not only sums numbers but also time. The syntax and usage is pretty much the same, but in handling data in time format, it is really important to set the format right. Figure 1. Using SUMIF with the time format Formula for single criteria =SUMIF(B5:B22,"James",D5:D22) Formula for...

How to Combine SUMIF with GREATER THAN and LESS THAN Functions

When we have to add data based on a given criteria in Excel, the SUMIF function provides the perfect solution. In this article, we will learn how to use SUMIF in combination with Greater Than and Less Than functions. Figure 1. SUMIF with greater than and less than functions Setting...

How to Use SUMIF Combined with Multiple Criteria

The SUMIF function in Excel is designed for only one criterion or condition. When we need to sum values based on multiple criteria, we can add two or more SUMIF functions, or we use a combination of SUM and SUMIF functions. Here’s how. Figure 1. SUMIF combined with multiple criteria...

Sum if between

Excel conditions sum and if can be combined to form sum if between conditions. This combination is necessary for adding cells or inputs which satisfy two or more criteria between given cell ranges in a sheet. This article provides a guide on how to use the sum if between conditions...

How to Sum Values Between Two Dates in Excel

In Excel, you can sum numeric value between two dates as conditions or criteria. In this case, you need to apply two dates as criteria, so you are going to deal with multiple criteria to sum these values. In this article, we are going to sum such values using two...

Add Cells Based on Blank / Not Blank Criteria

Using Excel SUMIF function you can sum the numbers from a range of cells that meet the criteria based on cells that do not contain any value (Blank) or cells that are contain a value (Not Blank). While working with data you come across to a situation where you need...