In Excel 2007 there is a AVERAGEIF function (look it up in help) that should
do the trick

If you are in Excel 2003 this is not available but you can still achieve
your result by doing a conditional sum and dividing by the number of days
like this

=SUMIF(Sheet1!B9:B39,"=" & B10,Sheet1!AE9:AE39)/COUNTIF(Sheet1!B9:B39,"="
& B10)
--
If this helps, please remember to click yes.


"Curtis" wrote:

I have a report sheet where

Cell b10 represent the day of the month

I need a formula that will look to a prior month sheet for the corresponding
day as identified in B10 and average the sum sales to that point

In the source sheet

Column B (rows 9 thru 39) = day of month
Column AE (row 9 thru 39) = sales
--
ce