Excel formula, or macro?, help.?

Question

I have a column listing date, project, and time spent. I need in a two seperate columns for excel to pull all information on all dates that match and total the hours. So, 8/17 5.25, 8/18 7.25, etc. Also, in two other columns for it to pull all projects that are the same and total the hours. So, Project A 4.5, Project B 3.75. The thing is, this is not static information as at the end of each week I will be adding all different information to the main list. So i cannot just say =sum of all these columns.. make sense?

Answer 1

To sum all items in D1:D100, where the date in A1:A100 is Aug 19, 2008:

=SUMIF(A1:A100, DATE(2008, 08, 19), D1:D100)

or, if C1 contains the date:

=SUMIF(A1:A100, C1, D1:D100)

To sum all items in col D, where col B contains "Project A":

=SUMIF(B1:B100, "Project A", D1:D100)