Excel 2007 Sumproduct foreach day in column?

I currently have a spread sheet will be populated without a set size when it comes to row count. I have a column for time that is populated ever time an entry is made.

Ex:

Please Login or Register  to view this content.

.

Now this will continue all the way through the report. Generally it is a month long, but can be longer. I was able to get the values for the month based on other columns.

Ex:

Please Login or Register  to view this content.

This will give me the whole reports value. I need to get this where it will count for 1 day at a time.

pseudo:

Please Login or Register  to view this content.