YTD Averages

You've helped me on this before but I can't get the formula to apply here.
I'm wanting Cells B-17 thru B-21 to show YTD averages for each of these applications. Please help one more time.
WB for Attaching.zip

Originally Posted by pjoaquin

Does this work for you:

=$B12/(SUMPRODUCT(($E$4:$E$55=ROW()-16)*($G$4:$G$55<>"")))

It takes your value in B12 (sum of 1st sundays YTD) and divides it by the count (sumproduct) of 1st Sundays that have a dollar amount in column G.

If three 1st Sundays have passed, but you don't have your dollars inserted into column G for the third Sunday yet, it will still only divide by two to get the average - which should be OK, since the YTD Sum in B12 won't yet have been updated either.

You can put this formula into cell B17, then copy the cell and PasteSpecial-Formulas into B18-B21. (So the $B12 will change to $B13, $B14, etc.)

Paul,
That works just fine. Thanks much for your help as I just can't seem to learn this Excel fast enough to use it. It's good to have someone that can bail us out when we can't find the "how-to's" on our own.