Hi all,

I have the following problem.

Column A are dates that I enter which is almost every date of the year.
Column B has hours that I enter in relation to the date in Column A.
Column C has price I enter in relation to the date in Column A.

i.e.

9/1/06 5.0 25.50
10/1/06 6.0 14.00
12/1/06 5.3 12.00
2/2/06 4.0 17.50

I would like to create a formula that will loom up Column A (date) and
calculate the total hours and total price for all dates that fit into a
particular month.

i.e. For January the total hours equals 16.3 and price 51.50.

Hope someone can help.

Thanx in advance