DEV Community

loading...

Excel Formulas to Sum the Values if Cells are Not Equal to Certain Value!!

excelgeek profile image Andrews Originally published at geekexcel.com on ・2 min read

In this tutorial, we will show the formulas to sum the values if the cells are not equal to a certain value in Excel Office 365. Let’s see them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Formulas to sum if cells are not equal to certain value
Formulas to sum if cells are not equal to certain value

General Formula:

  • The below formula will help to sum the values if cells are not equal to a certain value in Excel.

=SUMIF(range,”<>X”,sum_range)

Syntax Explanations:

  • SUMIF – The Excel SUMIF Function will help to sum the cells that meet a single condition or criteria.
  • Criteria (X)– It is the specific value or criteria which is used to sum the cells.
  • Sum-range – It represents the input values given in the worksheet.
  • Multiplication (*) – In this symbol will multiply any two values or numbers.
  • Comma symbol (,) – It is a separator which helps to separate a list of values.
  • Parenthesis () – The main purpose of this symbol is to group the elements.
  • Range – It represents the input data given in the worksheet.
  • Operator (<>) – This symbol represents “not equal to the certain value”.

Example:

  • In the below example image, we will show how to sum the values if cells are not equal to a specific value.
  • First, we will give the input values in Column C and Column D.
  • Then, enter the given formula in the formula bar section.
  • Finally, we will get the result in the selected Cell G3.

Example
Example

Wrap-Up:

Here, we described the formulas used to sum the value if cells are not equal to a certain value in Excel Office 365. Hope that this article is useful to you. If you have any queries/doubts, feel free to share it with us. Thank you so much for Reading!! Keep learning on Geek Excel!! *and Excel Formulas *!!

Read Also:

Discussion

pic
Editor guide