=SUMIF(A1:A5,">=10",A1:A5), this formula sums the total value in the range of cells A1 to A5, if the value is greater than or equal to 10.
In this example we have 3 values (10,48&21) those are satisfying our condition and the formula gives us the sum of them.
No comments:
Post a Comment