Past on skipped cell, write formula for skipped subtract

[Freemannew]

1. How do I past on the skipped cells "past"
2. On column I and J the formula should be immediate like =I6 - I3, J6 - J6 etc then autofill to get other cells. But here whenever there is "RAY" in column ID it will no longer be immediate but skipped to subtract non RAY like I9 - I 3 etc
Please how do I write the formula to represent all so I can autofill to get all

 

[Fluff]

Duplicate to: Past on skipped cell, write formula e for skipped subtract

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.