Thread
:
repeat a formula, skipping cells
View Single Post
#
2
Ron de Bruin
Posts: n/a
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.
Reply With Quote