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.
First, you need to have a clean and tidy group of data to work with.
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).
Once we are done, you will be able to calculate sum if cells not equal to value.