finding last and creating average amount income to date

[Jerry Kinder]

Hi,
In col B are dates in col F are the amounts paid. in A1 I want to create
the average months income. Generating the avearge using the part of the
month not just an entire month.

If I am at 10 days into a month or 20 days etc. the average will reflect
just that part of the month. So if I am at three months and 17 days have
the average month reflect that.

Thank you,
Jerry

 

[Bob Phillips]

=AVERAGE(IF((B2:B32<>"")*(B2:B32<=TODAY()),F2:F32))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)