This has kept me up typing for hours...

[GoodTrouble]

I have the formula:

=SUMIF('2005'!A122:A132,"Monday",'2005'!F122:F132)/COUNTIF('2005'!A122:A132,"Monday")

For colums I have C:Monday, E:Tuesday, etc...so in other words, there is an
empty colum between each colum. Is there a way to get Exel to fill the cells
in the same row to the right, every other one like that and change the day to
corespond with the colum??

Like that on is for Monday, I need everything in the formula to stay the
same, except for the "Monday" would change to "Tuesday" two cells over.

IT'S DRIVING ME CRAZY!!! Please Help!

[Bob Phillips]

Put the day names in a free row above the data, and refer to the cells, such
as

=SUMIF('2005'!A122:A132,$A$100,'2005'!F122:F132)/COUNTIF('2005'!A122:A132,$A
$100)

Also, why not use

=AVERAGE(IF('2005'!A122:A132=$A$100,'2005'!A122:A132,$A$100)

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"GoodTrouble" <[email protected]> wrote in message
news:[email protected]...
> I have the formula:
>
>
=SUMIF('2005'!A122:A132,"Monday",'2005'!F122:F132)/COUNTIF('2005'!A122:A132,
"Monday")
>
> For colums I have C:Monday, E:Tuesday, etc...so in other words, there is
an
> empty colum between each colum. Is there a way to get Exel to fill the
cells
> in the same row to the right, every other one like that and change the day
to
> corespond with the colum??
>
> Like that on is for Monday, I need everything in the formula to stay the
> same, except for the "Monday" would change to "Tuesday" two cells over.
>
> IT'S DRIVING ME CRAZY!!! Please Help!

[GoodTrouble]

Thanks for the suggestion, but this is just another way of writing the
formula, doesn't really solve my problem of needing it to copy to other cells
and update the name of the day only when copying it-Excel still changes the
A, and F reference to other letters...

"Bob Phillips" wrote:

> Put the day names in a free row above the data, and refer to the cells, such
> as
>
> =SUMIF('2005'!A122:A132,$A$100,'2005'!F122:F132)/COUNTIF('2005'!A122:A132,$A
> $100)
>
> Also, why not use
>
> =AVERAGE(IF('2005'!A122:A132=$A$100,'2005'!A122:A132,$A$100)
>
> which is an array formula, it should be committed with Ctrl-Shift-Enter, not
> just Enter.
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "GoodTrouble" <[email protected]> wrote in message
> news:[email protected]...
> > I have the formula:
> >
> >
> =SUMIF('2005'!A122:A132,"Monday",'2005'!F122:F132)/COUNTIF('2005'!A122:A132,
> "Monday")
> >
> > For colums I have C:Monday, E:Tuesday, etc...so in other words, there is
> an
> > empty colum between each colum. Is there a way to get Exel to fill the
> cells
> > in the same row to the right, every other one like that and change the day
> to
> > corespond with the colum??
> >
> > Like that on is for Monday, I need everything in the formula to stay the
> > same, except for the "Monday" would change to "Tuesday" two cells over.
> >
> > IT'S DRIVING ME CRAZY!!! Please Help!
>
>
>

[mphell0]

You need to make that reference static by placing a $ in front of them. Then
when you copy them to other cells the reference will not change

If in A2 you have =A1 when you copy it to column B it will change to =B1.
If you put =$A$1 when you copy it to B it remains =$A$1

[GoodTrouble]

Awesome! Thanks!!

"mphell0" wrote:

>
> You need to make that reference static by placing a $ in front of them.
> Then
> when you copy them to other cells the reference will not change
>
> If in A2 you have =A1 when you copy it to column B it will change to
> =B1.
> If you put =$A$1 when you copy it to B it remains =$A$1
>
>
> --
> mphell0
> ------------------------------------------------------------------------
> mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
> View this thread: http://www.excelforum.com/showthread...hreadid=510467
>
>