Dynamic YDT calculation for different divisions

Dear experts,


I need formula for dynamic ytd calculation for the scenario mentioned below.

YTD YTD YTD
Month Apr-13 Apr-13 Apr-13 May-13 May-13 May-13 June-13 June-13 June-13 May-13 May-13 May-13
Product type x y z x y z x y z x y z
sales executive
a 5 10 15 20 25 30 35 40 45 ? ? ?
b 4 8 12 5 7 11 12 69 79 ? ? ?

Thanks in advance.

Please post a sample workbook with the result you expect to get. Just by looking at the above post, we could not derive any output.

Sarang

Dear Sarang,
I have posted the problem with sample workbook. The link for the same is provided below.

Please go through the same and help me. Thanks!

http://www.excelforum.com/excel-form...-required.html