Please see the attached sheet wherein I require the following
Sheet2 contains the total summary where I require the formula for Total Profit and Loss for A and B for the months Apr, May and June
Secondly as and when I change A or B position in Apr, May or June the total should also automatically change in Sheet2.
For Eg. in Apr the current position of A is B4, when I change it to C4 and B4 becomes B the total should also change.
I hope you get my point
The example is for 3 months but in actual I have data for all 12 months.