Multiply Values on Same Date

[gozparlak]

How can I multiply Values in Date1 and merge in date2? Could you help me For example values in Date1 (2,3,2). Multiply them 2*3*2=12. And write 12 to date2 11.02.2014 date and value2 12.


Date1----------------------VALUE 1------------- DATE2-------- VALUE 2
11.02.2014----------------- 2------------------- 11.02.2014--- =2*3*2
11.02.2014----------------- 3------------------- 12.02.2014--- =2*2
11.02.2014----------------- 2------------------- 13.02.2014--- =4*1

12.02.2014----------------- 2-------------------
12.02.2014----------------- 2-------------------

13.02.2014----------------- 4-------------------
13.02.2014----------------- 1-------------------

[shukla.ankur281190]

Try

F2

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

[gozparlak]

When I try this formula, the result is 192 for 11.02.2014. But It must be 12.

[gozparlak]

Okay I correted it, Thank you very much shukla.ankur281190 You are perfect