Summing time in a dynamic range?

[Simon Lloyd]

Thanks for the replies, if you look at the sheet i intend to develop for summing hours and wages by month i have titles: Date | Hours | Average Wage, i am working on a formula to put in the hours column to calculate hours for a month the formula seemed to work (but of course summed all the hours so far because of SUM(WorkedTime), the formula , i thought relied on the value in A2 to be between 2 dates to produce a result however removing the value from A2 didnt change the result.

=IF(AND(OR($A2>="01/01/07",$A2<="31/01/07")),SUM(WorkedTime),0)

My ideal formula would be: IF Ax contained a month name Like "January" THEN SUM WorkedTime (column E) FOR all ROWS that fall in that month, something like

=IF(A2=MONTH,SUM(ALL ROWS MATCHING MONTH ON CLIENT SHEET),0)

although i wish it was this simple!

Regards,
SImon