Sum cells greater than a value

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


Built-in Functions

SUM - The total value of the numbers in a list, table or cell range.
IF - The value based on whether a certain 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


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top