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.
