I need to calculate an sum/average, however the divisor may be different based on the number of unique dates for each person.

Column H has the total hours for the given period.
Column G has the check dates for the employee.

So basically I need something like... =sum((H10/(# unique dates in range G5:G9))/2)

I'm trying to calculate the average # of hours being worked by employees each week. Since the report will also include those who have worked here for a time less than my report range, I need to account for that. We're paid biweekly, so I can only see 2 weeks worth of info at a time, thus why ultimately it then needs to be divided by 2 as the VP wants it based on a weekly #. I would prefer not to have to calculate the # of checks by hand.

Thanks for helping.