Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make typing "jump" to matching item(s) in drop-down list? | Excel Discussion (Misc queries) | |||
Weird question on filling in typing in excel | Excel Discussion (Misc queries) | |||
Can I auto fill a cell in one worksheet by typing a code number | Excel Worksheet Functions | |||
Excel hard code those #'s without deleting the formula or typing# | Excel Discussion (Misc queries) | |||
I need help getting Excel to auto-fill cells when I begin typing . | New Users to Excel |