(Msg. 1) Posted: Tue Aug 05, 2008 9:06 pm
Post subject: YTD Average Formula to continue on new worksheet Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
I have split up my worksheet so the first 6 mos is on one sheet and the last
6 months is on a second sheet. I need to bring over my YTD Average and
continue to be able to have the YTD Average update automatically as I enter
data each day. How do I do this?
(Msg. 2) Posted: Wed Aug 06, 2008 12:16 am
Post subject: Re: YTD Average Formula to continue on new worksheet [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Let's assume the first 6 months of data are on Sheet1 in the range A1:A100.
The second 6 months of data will be in the same range on Sheet2.
On Sheet2 in some cell enter this formula (just don't enter the formula in
the range A1:A100):
=AVERAGE(Sheet1!A1:A100,A1:A100)
--
Biff
Microsoft Excel MVP
"Arayne" <Arayne.RemoveThis@discussions.microsoft.com> wrote in message
news:563200B0-6116-44F8-BE56-26191D66D107@microsoft.com...
>I have split up my worksheet so the first 6 mos is on one sheet and the
>last
> 6 months is on a second sheet. I need to bring over my YTD Average and
> continue to be able to have the YTD Average update automatically as I
> enter
> data each day. How do I do this?
(Msg. 3) Posted: Fri Aug 22, 2008 8:03 am
Post subject: RE: YTD Average Formula to continue on new worksheet [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I'm trying to update cells in one worksheet from selections in a list box in
another worksheet. I'm using if statements in my cells that like to the
source cells, but whenever I change a selection on my list box (source cells)
the only way I get my destination cells on other worksheet to update is to
actually click on cell and then "execute" the formula....
I want the destination cell to automatically update without me actually have
to execute the If formula for the destination cell...
What am I doing wrong, and what should I do to automate this??
Thanks
"Arayne" wrote:
> I have split up my worksheet so the first 6 mos is on one sheet and the last
> 6 months is on a second sheet. I need to bring over my YTD Average and
> continue to be able to have the YTD Average update automatically as I enter
> data each day. How do I do this?
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