Subtraction formula
What formula can i use when subtracting numbers?
Question marked as
Top-ranking reply
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Question marked as
Top-ranking reply
2 replies
You can also use the sum() function. If you have two columns of numbers let's say income on column B and Expenses in column C, then you could get the final balance in a footer (or header ) row using the formula:
=sum(B)-sum(C)
Subtraction formula