Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to change a formula for a large group of cells | Excel Worksheet Functions | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Skipping cells while reorganizing data | Excel Discussion (Misc queries) | |||
Formula help for using a range of cells! | Excel Worksheet Functions | |||
A formula to check differrent cells | Excel Worksheet Functions |