Forum Discussion
Re: Excel Formulas
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.
1 Reply
- Awesome. Thank you so much.
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.
