In the following screenshot of an Excel (2010) spreadsheet, all but two columns (C & F) of a bank account register are shown. The remaining columns are present but have been hidden.
Because there are multiple entries for many of the days, a third column (G) is designated to display daily totals.
The daily totals in the screenshot spreadsheet were created manually using =SUM() but what formula in column G would generate those totals automatically. The problematic issue is that the number of values for each day is not constant and therefore the formula needs to be able to locate the first entry of the day and then take the sum from that entry down to the last entry of the day. Which Excel function will do that?