title: how to sum an amount above a specified number in Excel
body: <p>i am working with a table where all the values above 145 are marked red. i want to add only the amount greater than 145 in these values. e.g if i have 150 in one cell and 150 in other cell the result would be 10. i tried using <code>sumif</code> but it add all the numbers above 145. i can use <code>if</code> formula to calculate the values above 145 and then add them but i will have to make another table for that. if there a formula to cover this in one step so i dont have to make a separate table? i have to do this for every column. </p>
  
  <p><a href="https://i.stack.imgur.com/dxPcM.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dxPcM.jpg" alt="table"></a></p>