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