How to Calculate all PAYMENT by account number

Hi all expert

I have to sheet "sample" and "summary payment" that I want to calculate all payment from sheet "sample" to "summary payment". Kindly help how to calculate this payment. I allready posting sample file too . Thank you in advance

Try this in C3:

=SUMIFS(SAMPLE!$D$3:$D$21,SAMPLE!$B$3:$B$21,$B3,SAMPLE!$A$3:$A$21,">="&C$2,SAMPLE!$A$3:$A$21,"<="&EOMONTH(C$2,0))

Copy to right and down.

HI Phuocam

Wowww, yes running correctly. thank you for your help Phuocam.

regard
dolphino