Making Cell $ Amount Go Down With X

**lake.ryan** · 05-20-2017, 10:15 PM

Was not sure how to describe this but this is what I want to do, I am working on a sheet of my bills, I have my total debt in F5, G5 is blank, and from F5 to Z5 I have months, my goal is in each month when I make the payment I will put an X in that box, showing it was paid, did that, no code needed, BUT, what I want is for the debt in G5 to go down by a certain amount, in this case, $25 every time there is an X in all of row 5. This sounds relativley easy but I am new to Excel and am learning. Please help if this is even possible! I know I will have to use IF or COUNTIF, just not sure how to make it, in this example, 809 subtract 26 if X is entered in all of row 5, or even from H5:Z5 hope that helps.

**leelnich** · 05-21-2017, 12:26 AM

Hi Ryan, welcome to Excel Forum. If you attach a sample workbook (NOT a picture) to your post, you'll generally get more responses.
Remove any sensitive or extraneous info, just show us where your data is, what results you expect, and where you want them shown.
That will help us to quickly match our responses to your needs. Thanks!

To attach a workbook:
Click Edit Post (or just start a new reply.)
Click Go Advanced
Scroll down to Manage Attachments and click.
Now just Browse for your file, then click Upload. Simple!