IF FORMULA

[Nixson]

HI,

Could you please help me for below,

i need formula for to get month wise due & month wise Payment done. if due Payment done it should not reflect Payment due month wise other wise Payment done.

 

[Oaktree]

Try

G2 =SUMPRODUCT($B$2:$B$11,--(TEXT($C$2:$C$11,"mmm yyyy")=G1&" 2020"),--($D$2:$D$11=""))
G4 =SUMPRODUCT($B$2:$B$11,--(TEXT($D$2:$D$11,"mmm yyyy")=G3&" 2020"))

Then copy G2 & G4 right.

 

[Nixson]

HI

If payment is done, then value should reflect in payment done column as per the due date month

 

[Oaktree]

If you want row 4 to be based on the Due date and not the Payment date, try:

G4 =SUMPRODUCT($B$2:$B$11,--(TEXT($C$2:$C$11,"mmm yyyy")=G1&" 2020"),--($D$2:$D$11<>""))

 

[Nixson]

THANKS DEAR