This has kept me up typing for hours...
 

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!

This has kept me up typing for hours...
 

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:A1 32,$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" wrote in message
...
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!

This has kept me up typing for hours...
 

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:A1 32,$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" wrote in message
...
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!

This has kept me up typing for hours...
 

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

This has kept me up typing for hours...
 

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