Need a formula to copy end of day totals in another column

[dougkpga]

I have a sheet that has Date - Daily Entry and Running Total (A B C)

I would like to get an end of day total for the days (I have added Column D for the sample)

If possible would there be formulas to from a table as in columns F and G that I have added either on the same worksheet or a new worksheet (as on sample).

Thanks in advance for any help.

[bebo021999]

Try in D2:

Please Login or Register  to view this content.

Drag down
In F2, list of unique date from column A

Please Login or Register  to view this content.

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
G2:

Please Login or Register  to view this content.

Drag all down

[dougkpga]

Thanks a lot for your help bebo. I will try on my original sheet.