Forum Discussion
Solved
Excel Formulas
I need assistance with an excel formula to identify cells with the number greater than 100 and then add the amounts over 100. If I have cells 3 thru 8 and two of the cells have 101 and another 150, I need the result of the formula to be 51. I need to add the amounts over 100 for the data range.
Let's say you have numbers in A2:A10.
=SUM(IF(A2:A10>100,A2:A10-100))
If you don't have Microsoft 365 or Office 2021, confirm the formula with Ctrl+Shift+Enter.
2 Replies
Let's say you have numbers in A2:A10.
=SUM(IF(A2:A10>100,A2:A10-100))
If you don't have Microsoft 365 or Office 2021, confirm the formula with Ctrl+Shift+Enter.
- Awesome. Thank you so much.
