(Msg. 1) Posted: Wed Aug 20, 2008 1:18 pm
Post subject: Dynamic formula Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
I have a formula that calculates an average of either 10 or 11 rows of data.
I would like to be able to make the formula dynamic so that I can average
either 10 or 11 rows, based on a countif function and some other data.
(Msg. 2) Posted: Wed Aug 20, 2008 1:23 pm
Post subject: Re: Dynamic formula [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"Jason" <Jason DeleteThis @discussions.microsoft.com> wrote in message
news:1AED1E16-21C4-4CF1-90B6-B5F69EB2F32C@microsoft.com...
>I have a formula that calculates an average of either 10 or 11 rows of
>data.
> I would like to be able to make the formula dynamic so that I can average
> either 10 or 11 rows, based on a countif function and some other data.
>
> Any help is appreciated.
> --
> Thanks,
>
> Jason
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