finding last and creating average amount income to date

  • Thread starter Thread starter Jerry Kinder
  • Start date Start date
J

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
 
=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)
 
Back
Top