(Msg. 1) Posted: Wed Nov 04, 2009 7:42 am
Post subject: average range growing Archived from groups: microsoft>public>excel>misc (more info?)
I have a CPK sheet that i am having a CMM dump data into automaticlly. My
problem is I need the formula for the average to grow along with the additon
of cells that I insert with a macro. Right now the formula is just
=AVERAGE(E12:E12)because there is only one line, but when I insert a cell I
want it to change to =AVERAGE(E12:E13)....etc..etc. How would I accomplish
this?
(Msg. 2) Posted: Wed Nov 04, 2009 7:52 am
Post subject: Re: average range growing [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Josh
Use this formula:
=SUM(E12:E50)/COUNTA(E12:E50)
Regards,
Per
On 4 Nov., 16:42, jamccarley <jamccar....DeleteThis@discussions.microsoft.com>
wrote:
> I have a CPK sheet that i am having a CMM dump data into automaticlly. My
> problem is I need the formula for the average to grow along with the additon
> of cells that I insert with a macro. Right now the formula is just
> =AVERAGE(E12:E12)because there is only one line, but when I insert a cell I
> want it to change to =AVERAGE(E12:E13)....etc..etc. How would I accomplish
> this?
>
> Thanks
> Josh McCarley
(Msg. 3) Posted: Wed Nov 04, 2009 9:22 am
Post subject: RE: average range growing [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
If the macro is adding data, have the same macro modify the =AVERAGE() formula.
--
Gary''s Student - gsnu200908
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office