Month to Month Expenditure Tally (IF THEN Logic)

Hello,

I am trying to track expenses from month to month and subtract any money that exceeds the allocated funds for each month from the next's. For example, each month has an allowance of $300; if January's expenditure is $350, then February's allowance should be reduced to $250. I am able to trigger this for February but cannot get the subtractions to stack. This means that March's allowance will not take into account January and February's combined expenditures.

Below is the formula I am using for February (which works), followed by the one I have been tinkering with for March:

February

=IF(JAN!C4>480,480-JAN!C4)-IMSUM(A6:A14)

March

=IF(JAN!C4>480,480-JAN!C4)*AND(IF(FEB!C4>JAN!B4,480-IMSUM(FEB!A6:A14)-IMSUM(A6:A14)))

I have also included the document I am working from for reference (see: attached). Please note, I am using Excel on a Mac.

Any help would be greatly appreciated!

Welcome to the forum.

If your version is for Mac, please add this to your forum profile with the version number.

This is a problem:

='C:\Users\ritman\Desktop\My Files\Lifestyle\Finances\[Budget.xlsx]MASTER'!D9

We don't have access to that workbook, so there are #REF! errors in your sample. Please fix and reattach.

Thanks, but it's not showing in your profile. It just says MS-Off Ver: 16.57. It needs to be 16.57 for Mac.

I will have another quick look (but I'm off out very soon, so it may fall to someone else to help you).

Still no dice - sorry!

AliGW on MS365 Insider (Windows) 64 bit

	A	B	C
1	EXPENDITURE
2	Float	Available	Total Spent
3	#REF!	#REF!	$ 500.00
4	Value	Date	Notes
5	$ 20.00	01/01/2022
6	$ 50.00	07/01/2022

Sheet: JAN

You need to change any EXTERNAL references to hard-coded values.

You're welcome and thanks for the useful update.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.