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
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top