Sumifs for a forecast

[xxkaykayxx]

Hi, So I am trying to create a weekly cash-flow forecast, that pulls data from another tab and using the expected payment date phases the income into the correct weeks by client. I have seen this done before but my formula is slightly off it seems. [TABLE="width: 500, align: right"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]Cash flow Forecast[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Week Ending[/TD]
[TD][/TD]
[TD]01/08/17[/TD]
[TD]07/08/17[/TD]
[TD]14/08/17[/TD]
[TD]21/08/17[/TD]
[TD]28/08/17[/TD]
[/TR]
[TR]
[TD]27/08/17[/TD]
[TD]31/07/17[/TD]
[TD]06/08/17[/TD]
[TD]13/08/17[/TD]
[TD]20/08/17[/TD]
[TD]27/08/17[/TD]
[TD]03/09/17[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Client A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Client B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]















The formula i was attempting was: =SUMIFS('Debtors List'!$F:$F,'Debtors List'!$A:$A,"'Debtors List'!A5",'Debtors List'!$E:$E,">"&B$4,'Debtors List'!$E:$E,"<"&D$3)

Debtors List Tab: (Col A-F)
[TABLE="width: 500"]
<tbody>[TR]
[TD]Client Code[/TD]
[TD]Client ShortName[/TD]
[TD]Invoice No[/TD]
[TD]Date[/TD]
[TD]Expected Payment Date[/TD]
[TD]Balance[/TD]
[/TR]
[TR]
[TD]AAAA[/TD]
[TD][/TD]
[TD]0001[/TD]
[TD]25/07/17[/TD]
[TD]24/08/17[/TD]
[TD]10000[/TD]
[/TR]
[TR]
[TD]AAAA[/TD]
[TD][/TD]
[TD]0002[/TD]
[TD]31/07/17[/TD]
[TD]30/08/17[/TD]
[TD]12000[/TD]
[/TR]
[TR]
[TD]BBBB[/TD]
[TD][/TD]
[TD]0003[/TD]
[TD]1/08/17[/TD]
[TD]31/08/17[/TD]
[TD]5000[/TD]
[/TR]
</tbody>[/TABLE]

Please help if you can

 

[duckandcover]

Try this

=SUMIFS('Debtors List'!$F$2:$F$4,'Debtors List'!$A$2:$A$4,$A4,'Debtors List'!$E$2:$E$4,">"&C2,'Debtors List'!$E$2:$E$4,"<"&C3)

I've made some assumptions from your post, these are

Your week start date is in a cell and the week end date is in the cell below it

Also I have put the client name in column A on the second sheet and used that as a reference to search

I've got a copy of what you've posted and it appears to work for me

 

[xxkaykayxx]

Try this

=SUMIFS('Debtors List'!$F$2:$F$4,'Debtors List'!$A$2:$A$4,$A4,'Debtors List'!$E$2:$E$4,">"&C2,'Debtors List'!$E$2:$E$4,"<"&C3)

I've made some assumptions from your post, these are

Your week start date is in a cell and the week end date is in the cell below it

Also I have put the client name in column A on the second sheet and used that as a reference to search

I've got a copy of what you've posted and it appears to work for me

Brilliant. I will give it a try and let you know

 

[xxkaykayxx]

It works brilliantly, Thanks so much for your help