Thanks for the help in advance. I can’t figure out a normal formula to do this and have few programming skills to do this via a macro.

I have 3 columns.

Column A has a date (e.g. 7/1/2011) every nth row.
Column B will have several rows in between two dates with numerical values.
Column C needs to sum the values belonging to each individual date


Thank you!