| 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! |
| 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 | |||
Threaded Mode
