Cumulative Sum using SUMIFS (with multiple conditions)

(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