Sum to a certain Column 1

[binaryfingers]

Hi

I have a range of weekly dates running horizontal from Column F to Column BE. on row 2

I have been trying to find a solution to sum row 7 from Column F to the column that matches the current weekly date.

I believe it is a combination of Sum(indirect(match))) but not sure if there is an easier way?

Any suggestions on how to achieve this will be greatly appreciated.

Thanks,

 

[GlennUK]

Or Sum(Offset(ref,0,0,1,Match( etc etc.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[yogia]

Hi binaryfingers:

In addition to suggestion by Glenn, following is another way ...

   |E         F         G        H         I         J         K
---|-------------------------------------------------------------------
 1 |TodayDate	            WeekBegin (Sunday) Dates			
 2 |[highlight]5/30/2007[/highlight] 4/29/2007 5/6/2007 5/13/2007 5/20/2007 5/27/2007 6/3/2007
 3 |
 4 |
 5 |
 6 |
 7 |[highlight]29[/highlight]	    11	    3	    8	     5	     2	     4

formula in cell E7 is ...

=SUM(F7:INDEX(7:7,LOOKUP(E2,2:2,COLUMN(2:2))))

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com

 

[binaryfingers]

Yogia

Excellent, twice in two days you have helped me save a lot of time!

Thanks again,

 

[yogia]

You Are Very Welcome binaryfingers!

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com