Sum cells that are numbers and greater than a value

{=SUM( IF (cellrange > 0, cellrange))}

Built-in Functions

SUM - The total of the numerical values.
IF - The value based on whether a condition is True or False.

Related Formulas

Sum cells that meet 1 condition
Sum cells equal to 2 values
Sum cells equal to 3 or more values
Sum cells equal to a value
Sum cells equal to a value case sensitive