How to do a Sum If Greater Than Zero in Excel?

By /

You can use the following formula in Excel to only sum values that are greater than zero in a particular range:

=SUMIF(B2:B9, ">0", C2:C9)

This particular formula calculates the sum of values in the range C2:C9 only where the corresponding cell in the range B2:B9 is greater than zero.

The following example shows how to use this formula in practice.

Example: SUMIF Greater Than Zero in Excel

Suppose we have the following dataset in Excel that contains information about ratings for various hotels along with the number of customers who stayed at each hotel during the past week:

Suppose we would like to calculate the sum of customers only for the hotels that have a rating greater than zero.

We can type the following formula into cell E2 to do so:

=SUMIF(B2:B9, ">0", C2:C9)

The following screenshot shows how to use this formula in practice:

We can see that the sum of customers only for hotels with a rating greater than zero is 167.

We can confirm this by manually identifying each of these hotels:

We can confirm that the sum of customers for these hotels is 167:

Sum of Customers: 15 + 22 + 28 +54 + 12 + 36 = 167

=SUMIF(B2:B9, ">=0", C2:C9)

x

Related terms:

  1. How to calculate the average of a range only if greater than zero in Excel?
  2. How to use SUMPRODUCT only with values greater than zero in Excel?
  3. How do I count how many cells are greater than zero?
  4. How to use Google Sheets: COUNTIF Greater Than Zero
  5. How to Sum Cells in Excel if Date is Greater Than
  6. PySpark: Replace Zero with Null How to Replace Zero with Null in PySpark?
  7. How do I sum a column if the value in that column is less than a given value?
  8. Non-Zero-Sum Game
  9. Zero-Sum Game
  10. Excel: Highlight Cell if Greater Than Another Cell