Sum up the last number in column

[Leonardo Da Vinci]

Hi all,

I would like some help with the following problem.

If in column A I was to have dates of a month and in column B I had numbers
up until the second last day of the month, how can I take the last number
that has been entered in column B and divide it by the total number of days
in the month (column A) or the number of days up until and including the day
that the number was entered into column B.

Thanks in advance for your help.

 

[Frank Kabel]

Hi
try
=LOOKUP(9.999999999E307,B:B)/COUNTA(B:B)

 

[Leonardo Da Vinci]

Thank you ... it worked great. Although I did need to change COUNTA(B:B) to
COUNTA(A:A).