Formula Copy Help

[lillyy]

Dear Friends,

I need urgent help about the formula below.I am pasting special or dragging the formula but I cant get the correct formula copiing..

I need to get the result of this formula from the short way of copying..

D1 ::: =(((A5*A6)+(B3*B4))/(A5+B3)+((A7*A8)+(B5*B6))/(A7+B5))/2
D5 ::: =(((A7*A8)+(B5*B6))/(A7+B5)+((A9*A10)+(B7*B8))/(A9+B7))/2
D9 ..................

This is the serie of the formula..I need the short way of this ..Please..

 

[PGuru]

If you highlight D1 and D2 (which is blank), then copy it down, you will get alternate cells of blank and formulae, which will give the answer you want in D5 & D9.

BUT that only works if the formula in D3 is acceptable to you.