repeating functions

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

I have two worksheets. One with lots of data, and one that i want to
put aggregates of *parts* of that data on. So, on sheet 2, cell A1, I
might want to do a sumif function of cells G1-G20 from sheet 1. Then
for A2, I just want to sumif the next twenty (G21-40). How can I ask
Excel to repeat automatically picking up where I want it to leave off?
Thanks!

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
Hi Kevin
try the following formula in A1 on sheet 2
=SUM(OFFSET('sheet1'!$A$1,(ROW()-1)*20,0,20)
and copy down
 
Back
Top