repeat a formula, skipping cells

  • Thread starter Hucleberry Hound
  • Start date
H

Hucleberry Hound

Microsoft excel. Is it possible to quickly repeat, or copy, a formula down a
column skipping the same number of rows with each copy. e.g. give the total
of a1..a4 in b4 and copy this so that you get a5..a8 in b8, a9..a12 in b12,
etc.
 
R

Ron de Bruin

Hi

Select B1:B4 (b1:b3 = empty and in B4 =SUM(A1:A4))
And copy the four cells down
 
Top