(i) To get Sum of Amount corresponding to "Kamal" on 1st July
=SUMIFS(C5:C17,A5:A17,"1-Jul", B5:B17,"Kamal")
Answer : 345
(ii) To get Sum of Amount corresponding to "Kamal" between two dates.
=SUMIFS(C5:C17,A5:A17,"<=31 Jul",A5:A17,">=1 Jul",B5:B17,"Kamal")
Answer : 1215
