Please help to add and subtract opening and closing inventory...

[vaxo]

Can you please help in 1 period to subtract closing inventory and in onother to add same opening inventory with formula....

 

[vaxo]

There is no answor?

 

[Deepak]

There is no answor?

Patience man!!

You will get the answer as soon as someone understand the query.

 

[Marc L]

There is no answor?

There is no initial post starting with "Hi !" ? …
​

 

[vaxo]

I need to subtract 1200$ in firs 1 period year and this 1200 would be opening inventory to period 2 where i need to add to cost of sales but with formula only once to write in firts years range..

 

[David Evans]

The key to receiving a clear concise answer is to pose a similar question - it is not clear what you are trying to achieve, tbh; and you've also included some interesting {} around some of your formulae which had me thinking arrays?, but they're not, of course ....

You might try combining your "tables" into one and elaborating on your descriptions for clarity - you're requiring the reader to make too many assumptions, which will only give you a multitude of "answers"

 

[vaxo]

In first period 1200$ to appear in closing and in second period in opening this is all i need but not to write manually but with formula that can automate this task.

 

[vaxo]

In table one second table is only helper

 

[David Evans]

So you want the value in Cell D14 to be carried over to E13?
And If you had a further column, E14 to be carried over to F13? If that's the case, you use relative addressing.

 

[vaxo]

yes yes i want that

 

[David Evans]

OK - well look at the attached - it's very straightforward

 

[vaxo]

Thanks if other way is not possible..