• 466K Members
• 8,154 Online
• 563K Conversations

Contributor

# Formula Help

Hello All,

I am trying to come up with a differential formula to let me know how I am doing on a month to month basis.  So for example in Jan I earned 2,000 and then in Feb. I earned 2,600.  In the differential cell (shown in picture below) I want to subtract C6-C5 and it tells me I'm up 600 for the year.  so that's the easy part.  what I'm trying to figure out is how do I make a formula to subtract C6-C5 then C7-C6 then C8-C7 once inputted and so on and so on.  I attached a picture below to help.  ANY help is much appreciated.  thank you so much

8 Replies

# Re: Formula Help

Hi @spalmer

If you are looking to differentiate your current month income to the previous month, I would suggest adding another column next to monthly income and putting the formulas there. It makes more sense as you can track the whole year.

See image below for example:

I have also created for you an Excel file with the formula in action for you to test.

Hope that helps?

Cheers

Damien

# Re: Formula Help

I agree with Damien's suggestion but if you insist, then this should be your formula in C19:
=INDEX(C5:C16,COUNT(C5:C16))-
INDEX(C5:C16,COUNT(C5:C16)-1)

# Re: Formula Help

Thank you Damien, I really appreciate the info and ill definitely look into doing that. makes sense.

# Re: Formula Help

Thank you Twifoo! I really appreciate that formula. you and Damien have really helped me out with this. I have been trying to figure out this formula for about a month now haha. I really appreciate you guys taking the time to help me out. thank you again! I will use your formula along with damiens idea as well.

# Re: Formula Help

So one more question for you guys if you don't mind... using the same table as above but this time instead of subtracting C6-C5 and C7-C6.  How would I make a formula to subtract each month only from January.  So C6-C5, then C7-C5, then C8-C5 and so on?

thank you for your time and help

# Re: Formula Help

You may use C\$5 instead of C5 in first approach and

`=INDEX(C5:C16,COUNT(C5:C16))-C5`

in second one

# Re: Formula Help

Thank You Sergei! I really appreciate your time and help!

# Re: Formula Help

Glad that we can help @spalmer. Have a great time Excelling!

Cheers

Damien

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies