Sum up the last number in column

  • Thread starter Thread starter Leonardo Da Vinci
  • Start date Start date
L

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.
 
Thank you ... it worked great. Although I did need to change COUNTA(B:B) to
COUNTA(A:A).
 
Back
Top