Sumif, indirect and average?

Hi Folks,

a tricky formula (well for me at least)

I basically want to work out the average number of calls per hour for each day. and enter it into column G. (please see attached file)

however i need to be able to copy the formula downwards so that when the date changes so does the the mean (as it is now calculating the next days mean).

i have tried this:

=SUMIF(C:C,INDIRECT(C3),E:E)/(COUNTIF(C:C,INDIRECT(C3)))

This formula does not work but !!!

please help excel wizards.

You shouldn't need INDIRECT, try

=SUMIF(C:C,C3,E:E)/COUNTIF(C:C,C3)