A Abhijeet Active Member Sep 6, 2014 #1 Hi I have data in excel dates in column A i have table i want update between 2 dates Total of Amount. And 31mar amount.In attach file i show expected result so tell me how to do this Attachments Sum.xlsx 9.6 KB · Views: 1
Hi I have data in excel dates in column A i have table i want update between 2 dates Total of Amount. And 31mar amount.In attach file i show expected result so tell me how to do this
Hui Excel Ninja Staff member Sep 6, 2014 #2 G2: =SUMIFS(B$2:B$56,A$2:A$56,">="&E2,A$2:A$56,"<="&F2) H2: =SUMIF(A$2:A$56,F2,B$2:B$56) Copy G2:H2 Down
G2: =SUMIFS(B$2:B$56,A$2:A$56,">="&E2,A$2:A$56,"<="&F2) H2: =SUMIF(A$2:A$56,F2,B$2:B$56) Copy G2:H2 Down
