Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy formula with same cells involved
Can anyone tell me how to do this
Suppose I have put some no.s in cell A1, A2, A3, A4, A5 & B5. Now the cell A6 is the sum of no.s from A1 to A4 divided by A5. Now, I want cell B6, to have same formulae as A6, i.e., it should have sum of no.s in cells A1 to A4, but it should be divided by B5. If I copy paste from cell A6 to B6, the sum is of cells B1 to B4 though divided by B5, now manually changing it is not possible. Plz help, If it is not possible for cell B6 to be divided by B5, atleast can it be the sum of cells A1 to A4. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy drag formula down cells | Excel Worksheet Functions | |||
how copy formula and only paste into 20,000 cells | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Matching when spaces are involved | Excel Worksheet Functions | |||
How do I copy formula cells from one worksheet to another? | Excel Worksheet Functions |