Sum if cells are not equal to

To solve this problem, you’ve got the option to use either theSUMIFS functionor theSUMIF function.

The SUMIF function is an older function that supports only one criteria.

SUMIFS on the other hand can be configured to apply multiple criteria.

Excel formula: Sum if not blank

Both options are explained below.

SUMIFS solution

In the example shown, the solution is based on the SUMIFS function.

Note that the SUMIFS function isnotcase-sensitive.

Excel formula: Sum if cells are equal to

Also note that in the SUMIFS function,sum_rangealways comesfirst.

),see this page.

The SUMIF function is an older function in Excel that supports only a single condition.

Excel formula: Sum if x or y

Note that in the SUMIF function,sum_rangealways comeslast.

The result ($136) is the same as with the SUMIFS function above.

),see this page.

Excel SUMIF function

Criteria can be applied to dates, numbers, and text.

Excel SUMIFS function