Prev: Working hours
Next: IF FORMULA
From: edul on 5 Apr 2010 22:13
Hi

I need some help, i have a simple formula that sums for example AA40:AG40.
Every week this has to increment across 1 column ie. AB40:AH40 in week 2

Currently i'm adjusting these formulas manually. Is there an easier way to
do this?

Thanks
edul


From: Stefi on 6 Apr 2010 04:40
=SUM(OFFSET(AA$40,0,WEEKNUM(TODAY())-1,1,7))

--
Regards!
Stefi



„edul” ezt írta:

> Hi
>
> I need some help, i have a simple formula that sums for example AA40:AG40.
> Every week this has to increment across 1 column ie. AB40:AH40 in week 2
>
> Currently i'm adjusting these formulas manually. Is there an easier way to
> do this?
>
> Thanks
> edul
>
>
> .
>
 | 
Pages: 1
Prev: Working hours
Next: IF FORMULA