repeat a formula, skipping cells
 

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.

Hi

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Hucleberry Hound" <Hucleberry wrote in message
...
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.