software

I have the formula:

=SUMIF('2005'!A122:A132,quot;Mondayquot;,'2005'!F122:F132)/COUNTIF('2005'!A122:A132,quot;Mondayquot;)

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 quot;Mondayquot; would change to quot;Tuesdayquot; two cells over.

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

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)

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

quot;Bob Phillipsquot; wrote:

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


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: www.excelforum.com/member.php...oamp;userid=30153
View this thread: www.excelforum.com/showthread...hreadid=510467Awesome! Thanks!!

quot;mphell0quot; wrote:

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