View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GoodTrouble
 
Posts: n/a
Default 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!