Average formula

[Nan]

I just received some help with the following formula (I can't seem t
find my prior post).

=OFFSET($P$5,COUNTA($P5:$P56)-1,0)

It works great.......it returns the last number in my column. However
now I also need to get the average of that number. Can I somehow wor
that into this same formula?

Thanks

 

[Frank Kabel]

Hi
the average of one number is this number
If you want the average from this column P you may try
=SUM(OFFSET($P$5,0,0,COUNTA($P5:$P56))/COUNTA($P5:$P56)

 

[A.W.J. Ales]

Nan,

From the formula I conclude that you have a range which starts at P5 and
stops somewhere between P6 and P56.
You wanted (in the first formula) the value of the last cell and now you
want the average of the cells.

If correct : =AVERAGE($P$5:OFFSET($P$5,COUNTA($P$5:$P$56)-1,0))

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Nan]

Reading back over my question, I see that I didn't make too muc
sense.......sorry!

The column P that I am using is actually a cumulative total. So th
last number in the column is the total calls to date. I would like th
average of the total. So it would be 954.71 in the below exampl
(6683/7).

Calls
989
1731
2835
3859
4751
5727
6683

Sorry for the confusion

 

[Nan]

Thanks for all your help.........I got it to work.: