Hi,

I'm using the following formula:

=SUMPRODUCT(((Progress!$G$2:$G$998<=$B2)*(Progress!$G$2:$G$998>=$A2)*(Progress!$J$2:$J$998="not complete")))

I'm using this formula to count the number of "not complete" there are in column J between 2 dates: B2 = start of week and A2 = end of week. Column G has dates in them.

Instead of counting thr cells with "not complete", in "column I" I want to make formulas to take the average of the numbers by week. So i will get an average amount per week.

Do I use the same sort of formula or should I be using a different one?

Any help would be much appreciated

Thanks

Harry