Re: Sumif and autofill

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: "Biff" <biffinpitt@xxxxxxxxxxx>
Date: Wed, 1 Jun 2005 00:25:03 -0400

Hi!

Try:

=SUMIF(INDIRECT("Week"&ROW(1:1)&"!C7:L7"),100+ROWS($1:1)-1,INDIRECT("Week"&ROW(1:1)&"!C298:L298"))

Biff

"Grimzby" <Grimzby.1pxj2e_1117598707.3409@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:Grimzby.1pxj2e_1117598707.3409@xxxxxxxxxxxxxxxxxxxxxxxx
>
> Thanx....both work great:).....spent hours reading and couldnt find an
> answer.
> The 100 is numeric value....can it be made to autofill in increments of
> 1 also....
>
> Thanx again.
>
>
> --
> Grimzby
> ------------------------------------------------------------------------
> Grimzby's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=23905
> View this thread: http://www.excelforum.com/showthread.php?threadid=375420
>

.

References:
- Sumif and autofill
  - From: Grimzby
- Re: Sumif and autofill
  - From: Grimzby

Prev by Date: Re: Excel Calculation
Next by Date: Re: Spread***/VBA Project Consulting: 50% Discount or Even Free - Limited Time Only
Previous by thread: Re: Sumif and autofill
Next by thread: Linking from several cells of 1 spread*** to fewer of another?
Index(es):
- Date
- Thread