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 in a list, table or cell range.
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


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