formula for cell plus x amount of lines

  • Thread starter Thread starter cousin_jammie
  • Start date Start date
C

cousin_jammie

Hi everyone. I need a bit of help with a specific formula. I have 2
spreadsheets, one is a working list of daily data with a weekly total,
the other gives me a summary of the totals for each week.

When Im inserting the formula for each weekly total, I can copy the
line above (eg previous week) but excel automatically assigns the next
line from my source sheet eg: =SUM(SALES!U1851) will become
=SUM(SALES!U1852) What I want is a formula that says something like
=SUM(SALES!U1851 plus 100 rows).. this giving me the formula of
=SUM(SALES!U1951). Is there a code for this or will I have to change
the line number manually each week?

Id be grateful for any help anyone can give. I hope my explanation is
not too confusing.

Regards
Jan
 
Best to use a defined range that is self adjusting
insert>names>define>name it whatever>in the refers to box type
=offset($a$1,0,0,counta($a:$a),1)
then =sum(whatever)
 
Youre brilliant Don. That works a treat. Thankyou for replying. I lov
this forum :)

Regards
Ja
 
Back
Top