DailyCaffeine
New Member
- Joined
- Feb 9, 2022
- Messages
- 25
- Office Version
- 365
- Platform
- Windows
Good afternoon,
I would like some help with trying to make the formula I want.
Management Acc. Spreadsheet
"Actual" Spreadsheet
I am trying to make it so that the Year to Date adds up all the Global sum from April up until the date specified in A4 but I am unsure how to do it.
I have tried doing the following formula but I am guessing it is not working because it's using both columns and rows.
=SUMIFS('[Actual Spreadsheet.xlsx]Sheet 1'!$E$9:$J$12,'[Actual Spreadsheet.xlsx]Sheet 1'!$E$7:$J$7,"<="&A4,'[Actual Spreadsheet.xlsx]Sheet 1'!$D$9:$D$12,A11)
Please let me know what I am doing wrong and what I should be doing instead, it will be greatly appreciated !
I would like some help with trying to make the formula I want.
Management Acc. Spreadsheet
"Actual" Spreadsheet
I am trying to make it so that the Year to Date adds up all the Global sum from April up until the date specified in A4 but I am unsure how to do it.
I have tried doing the following formula but I am guessing it is not working because it's using both columns and rows.
=SUMIFS('[Actual Spreadsheet.xlsx]Sheet 1'!$E$9:$J$12,'[Actual Spreadsheet.xlsx]Sheet 1'!$E$7:$J$7,"<="&A4,'[Actual Spreadsheet.xlsx]Sheet 1'!$D$9:$D$12,A11)
Please let me know what I am doing wrong and what I should be doing instead, it will be greatly appreciated !