In this tutorial, you will learn how to calculate sum if cells not equal to value in Excel.

Use SUMIF or SUMIFS in Excel to add values that don’t match a predetermined set of parameters. You can use either tool depending on the information you have.

Once you are ready, we can start by using real-life scenarios to help you understand how to calculate sum if cells not equal to value in Excel.

Table of Contents

## Anatomy of SUMIF Function

=SUMIF(range, criteria, [sum_range])

The SUMIF function is used to add values in a range that satisfy certain conditions.

## SUMIF Cells Not Equal to Value in Excel

Before we begin we will need a group of data to be used to calculate sum if cells not equal to value in Excel.

### Step 1

First, you need to have a clean and tidy group of data to work with.

### Step 2

In this example, we want to sum the revenue for all products other than Product C. To do that, we will insert the following formula =SUMIF(A1:A7, “<>C”, B1:B7).

### Step 3

Once we are done, you will be able to calculate sum if cells not equal to value.