Cash-flow planning per day

Y

YossiVan

New Member
Joined
Feb 7, 2019
Messages
6
Hello,

My goal is to show the correct total amount per day that will be deposited by extracting the information from contract details.

here is my formula:
Code: 
=SUMIF(Contrats!$D$3:$D$10000,$L3,Contrats!$H$3:$H$10000)+SUMIFS(Contrats!$I$3:I$10000,Contrats!$D$3:$D$10000,"<"&$L3,Contrats!$J$3:$J$10000,">="&$L3)

My goal is to have a sum of all the cash flows that will be deposited per day.
Column D represents start date
Column H represents first monthly (helps for specific conditions)
Column I represents regular monthly payment
Column J represents the final date

here is an example of two contracts to demonstrate my issue:

  1. Total yearly amount of 36$ that start on 01/01/2019 for 12 months
  2. Total yearly amount of 120$ that start on 01/02/2019 for 12 month

On L3 I typed 01/01/2019 and dragged it until L730 which represents 31/12/2020. typed the formula to M3 and dragged it down.

The result I get is 3$ for 01/01/2019(M3) which is correct but the result i get for 02/01/2019(M4) is still 3$ which is incorrect (supposed to be blank). If I go to 01/02/2019(M35) I do get the correct amount of 13$ (represents 3+10).

The worst part is I had this working at one point and cannot understand how it is not anymore.

Your help is greatly appreciated.
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Sort by date Sort by votes
so, just fyi, your formula has a misspelling, 'contrats' should be 'contracts', also part of your formula is missing the dollar sign before the I ... Contrats!$I$3:I$10000 should be Contrats!$I$3:$I$10000

With that said, if you want per day, why the second sumifs? not understanding the second sumifs, can you clarify?
 
Upvote 0
CyrusTheVirus said:
so, just fyi, your formula has a misspelling, 'contrats' should be 'contracts', also part of your formula is missing the dollar sign before the I ... Contrats!$I$3:I$10000 should be Contrats!$I$3:$I$10000

With that said, if you want per day, why the second sumifs? not understanding the second sumifs, can you clarify?
Click to expand...

Sorry for not specifying, "Contrats" is the correct spelling in french which the language in which this file will be. I corrected the missing $ thank you.

The second sumifs in theory should add up all deposits that are to be deposited the same day. Say there are 3 contracts with the same deposit date, the second sumifs will do the necessary addition.

hope that clarifies.
 
Upvote 0
can you copy/paste data from your worksheet(s) into your reply so i can see what you are referring to?
 
Upvote 0
[TABLE="width: 1281"]
<colgroup><col><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD="colspan: 9"]Contrats(Row B)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Nom/Code Client[/TD]
[TD] Montant Total [/TD]
[TD]Paiement Initial[/TD]
[TD]% Premier Paiement[/TD]
[TD]Nombres de Versements[/TD]
[TD] [/TD]
[TD] Premier Paiement [/TD]
[TD] Paiement Régulier [/TD]
[TD]Paiement Finale[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]#1[/TD]
[TD="align: left"]abc/001243[/TD]
[TD="align: left"] $ 360.00[/TD]
[TD]01/01/2019[/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD] [/TD]
[TD="align: left"] $ 30.00[/TD]
[TD="align: left"] $ 30.00[/TD]
[TD]01/01/2020[/TD]
[TD][/TD]
[TD="align: right"]01/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#2[/TD]
[TD="align: left"]abcs/001251[/TD]
[TD="align: left"] $ 1,400.00[/TD]
[TD]15/01/2019[/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD] [/TD]
[TD="align: left"] $ 116.67[/TD]
[TD="align: left"] $ 116.67[/TD]
[TD]15/01/2020[/TD]
[TD][/TD]
[TD="align: right"]02/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#3[/TD]
[TD="align: left"]abce/00010[/TD]
[TD="align: left"] $ 140.00[/TD]
[TD]20/01/2019[/TD]
[TD="align: right"]25%[/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD="align: left"] $ 35.00[/TD]
[TD="align: left"] $ 21.00[/TD]
[TD]20/07/2019[/TD]
[TD][/TD]
[TD="align: right"]03/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#4[/TD]
[TD="align: left"]Test[/TD]
[TD="align: left"] $ 1.00[/TD]
[TD]22/01/2019[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD="align: left"] $ 1.00[/TD]
[TD="align: left"] $ 1.00[/TD]
[TD]22/02/2019[/TD]
[TD][/TD]
[TD="align: right"]04/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#5[/TD]
[TD="align: left"]Test2[/TD]
[TD="align: left"] $ 1.00[/TD]
[TD]01/02/2019[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD="align: left"] $ 1.00[/TD]
[TD="align: left"] $ 1.00[/TD]
[TD]01/03/2019[/TD]
[TD][/TD]
[TD="align: right"]05/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#6[/TD]
[TD="align: left"]Test3[/TD]
[TD="align: left"] $ 1.00[/TD]
[TD]01/03/2019[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD="align: left"] $ 1.00[/TD]
[TD="align: left"] $ 1.00[/TD]
[TD]01/04/2019[/TD]
[TD][/TD]
[TD="align: right"]06/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#7[/TD]
[TD="align: left"]Test4[/TD]
[TD="align: left"] $ 1.00[/TD]
[TD]05/03/2019[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD="align: left"] $ 1.00[/TD]
[TD="align: left"] $ 1.00[/TD]
[TD]05/04/2019[/TD]
[TD][/TD]
[TD="align: right"]07/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]08/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]09/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]10/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]11/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]12/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]13/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]14/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]15/01/2019[/TD]
[TD="align: right"]146.6667[/TD]
[/TR]
[TR]
[TD]#16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]16/01/2019[/TD]
[TD="align: right"]146.6667[/TD]
[/TR]
[TR]
[TD]#17[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]17/01/2019[/TD]
[TD="align: right"]146.6667[/TD]
[/TR]
[TR]
[TD]#18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]18/01/2019[/TD]
[TD="align: right"]146.6667[/TD]
[/TR]
[TR]
[TD]#19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]19/01/2019[/TD]
[TD="align: right"]146.6667[/TD]
[/TR]
[TR]
[TD]#20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]20/01/2019[/TD]
[TD="align: right"]181.6667[/TD]
[/TR]
[TR]
[TD]#21[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]21/01/2019[/TD]
[TD="align: right"]167.6667[/TD]
[/TR]
[TR]
[TD]#22[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]22/01/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#23[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]23/01/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#24[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]24/01/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#25[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]25/01/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#26[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]26/01/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#27[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]27/01/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#28[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]28/01/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#29[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]29/01/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#30[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]30/01/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#31[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]31/01/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#32[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]01/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#33[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]02/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#34[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]03/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#35[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]04/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#36[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]05/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#37[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]06/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#38[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]07/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#39[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]08/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]09/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#41[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]10/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#42[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]11/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#43[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]12/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#44[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]13/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#45[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]14/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#46[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]15/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#47[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]16/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#48[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]17/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#49[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]18/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]19/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#51[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]20/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#52[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]21/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#53[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]22/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#54[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]23/02/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#55[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]24/02/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#56[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]25/02/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#57[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]26/02/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#58[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]27/02/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#59[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]28/02/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#60[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]01/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#61[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]02/03/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#62[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]03/03/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#63[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]04/03/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#64[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]05/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#65[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]06/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#66[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]07/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#67[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#68[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]09/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#69[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]10/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#70[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]11/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#71[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]12/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#72[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]13/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#73[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]14/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#74[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]15/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#75[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]16/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#76[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]17/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#77[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]18/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#78[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]19/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
YossiVan said:
[TABLE="width: 1281"]
<colgroup><col><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD="colspan: 9"]Contrats(Row B)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Nom/Code Client[/TD]
[TD] Montant Total [/TD]
[TD]Paiement Initial[/TD]
[TD]% Premier Paiement[/TD]
[TD]Nombres de Versements[/TD]
[TD] [/TD]
[TD] Premier Paiement [/TD]
[TD] Paiement Régulier [/TD]
[TD]Paiement Finale[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]#1[/TD]
[TD="align: left"]abc/001243[/TD]
[TD="align: left"] $ 360.00[/TD]
[TD]01/01/2019[/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD] [/TD]
[TD="align: left"] $ 30.00[/TD]
[TD="align: left"] $ 30.00[/TD]
[TD]01/01/2020[/TD]
[TD][/TD]
[TD="align: right"]01/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#2[/TD]
[TD="align: left"]abcs/001251[/TD]
[TD="align: left"] $ 1,400.00[/TD]
[TD]15/01/2019[/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD] [/TD]
[TD="align: left"] $ 116.67[/TD]
[TD="align: left"] $ 116.67[/TD]
[TD]15/01/2020[/TD]
[TD][/TD]
[TD="align: right"]02/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#3[/TD]
[TD="align: left"]abce/00010[/TD]
[TD="align: left"] $ 140.00[/TD]
[TD]20/01/2019[/TD]
[TD="align: right"]25%[/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD="align: left"] $ 35.00[/TD]
[TD="align: left"] $ 21.00[/TD]
[TD]20/07/2019[/TD]
[TD][/TD]
[TD="align: right"]03/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#4[/TD]
[TD="align: left"]Test[/TD]
[TD="align: left"] $ 1.00[/TD]
[TD]22/01/2019[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD="align: left"] $ 1.00[/TD]
[TD="align: left"] $ 1.00[/TD]
[TD]22/02/2019[/TD]
[TD][/TD]
[TD="align: right"]04/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#5[/TD]
[TD="align: left"]Test2[/TD]
[TD="align: left"] $ 1.00[/TD]
[TD]01/02/2019[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD="align: left"] $ 1.00[/TD]
[TD="align: left"] $ 1.00[/TD]
[TD]01/03/2019[/TD]
[TD][/TD]
[TD="align: right"]05/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#6[/TD]
[TD="align: left"]Test3[/TD]
[TD="align: left"] $ 1.00[/TD]
[TD]01/03/2019[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD="align: left"] $ 1.00[/TD]
[TD="align: left"] $ 1.00[/TD]
[TD]01/04/2019[/TD]
[TD][/TD]
[TD="align: right"]06/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#7[/TD]
[TD="align: left"]Test4[/TD]
[TD="align: left"] $ 1.00[/TD]
[TD]05/03/2019[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD="align: left"] $ 1.00[/TD]
[TD="align: left"] $ 1.00[/TD]
[TD]05/04/2019[/TD]
[TD][/TD]
[TD="align: right"]07/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]08/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]09/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]10/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]11/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]12/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]13/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]14/01/2019[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]#15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]15/01/2019[/TD]
[TD="align: right"]146.6667[/TD]
[/TR]
[TR]
[TD]#16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]16/01/2019[/TD]
[TD="align: right"]146.6667[/TD]
[/TR]
[TR]
[TD]#17[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]17/01/2019[/TD]
[TD="align: right"]146.6667[/TD]
[/TR]
[TR]
[TD]#18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]18/01/2019[/TD]
[TD="align: right"]146.6667[/TD]
[/TR]
[TR]
[TD]#19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]19/01/2019[/TD]
[TD="align: right"]146.6667[/TD]
[/TR]
[TR]
[TD]#20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]20/01/2019[/TD]
[TD="align: right"]181.6667[/TD]
[/TR]
[TR]
[TD]#21[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]21/01/2019[/TD]
[TD="align: right"]167.6667[/TD]
[/TR]
[TR]
[TD]#22[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]22/01/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#23[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]23/01/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#24[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]24/01/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#25[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]25/01/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#26[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]26/01/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#27[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]27/01/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#28[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]28/01/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#29[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]29/01/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#30[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]30/01/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#31[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]31/01/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#32[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]01/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#33[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]02/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#34[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]03/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#35[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]04/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#36[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]05/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#37[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]06/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#38[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]07/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#39[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]08/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]09/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#41[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]10/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#42[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]11/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#43[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]12/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#44[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]13/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#45[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]14/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#46[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]15/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#47[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]16/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#48[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]17/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#49[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]18/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]19/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#51[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]20/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#52[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]21/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#53[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]22/02/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#54[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]23/02/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#55[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]24/02/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#56[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]25/02/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#57[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]26/02/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#58[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]27/02/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#59[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]28/02/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#60[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]01/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#61[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]02/03/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#62[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]03/03/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#63[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]04/03/2019[/TD]
[TD="align: right"]168.6667[/TD]
[/TR]
[TR]
[TD]#64[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]05/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#65[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]06/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#66[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]07/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#67[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#68[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]09/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#69[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]10/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#70[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]11/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#71[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]12/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#72[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]13/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#73[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]14/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#74[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]15/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#75[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]16/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#76[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]17/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#77[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]18/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
[TR]
[TD]#78[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: left"] [/TD]
[TD="align: left"] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="align: right"]19/03/2019[/TD]
[TD="align: right"]169.6667[/TD]
[/TR]
</tbody>[/TABLE]
Click to expand...

based on the data, which cells (dates) that you believe produced wrong results?
 
Upvote 0
AlanY said:
based on the data, which cells (dates) that you believe produced wrong results?
Click to expand...

on the column next to the daily calendar, there are no deposits on 02/01/2019 but it shows 30. I know that my formula is not correct and is calulating the deposit on that is on 02/01/2019 (which is 0) + the deposit on 01/01/2019 which is 30. Therefore it shows 30. I do not know how to make it so that it only shows the sum of deposits on the same of day of each month in between the date of contracts.
 
Upvote 0
Here is the solution to the issue:

it consists of adding a column that display the day number inserted in column H, then tweaking the formula to this:

Code: 
=SUMIF(Contrats!$D$3:$D$10000,$L3,Contrats!$I$3:$I$10000)+SUMIFS(Contrats!$J$3:J$10000,Contrats!$D$3:$D$10000,"<"&$L3,Contrats!$K$3:$K$10000,">="&$a2,Contrats!$H$3:$H$10000,DAY($L3))

Thank you all for your assistance.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
How merging by sum DEBIT,CREDIT columns for each name
2 3
Replies
27
Views
382
Abdo
A
O
  • Solved
Put amount in DEBIT,CREDIT columns based on matching part of item
Replies
9
Views
207
Omran Y
O
M
  • Question Question
Index Match function List based on date
Replies
7
Views
326
Fluff
Fluff
H
  • Question Question
Cashflow forecast based on start dates and either monthly, bi-monthly, quarterly, annually
Replies
2
Views
792
felixstraube
F
S
  • Solved
SumIf problem
Replies
2
Views
366
sharshra
S

Forum statistics

Threads
1,224,825
Messages
6,181,189
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top