[FIXED] How to sum two different sheets of excels in third sheet using phpexcel

Issue

Am using PhpExcel Library to export huge details of my database. Anyway i tried to export my details. I just created three different sheets. One sheet name is "Week 1", Another one is "Week 2". Again the third one name is "Total". I am getting error when add first value of (ie.E5) 'Week 1' and first first value of (ie.E5) 'Week 2'.

If I apply any formula inside the same sheet (Ex: If i add first and second value of 'Week 1') , it is working fine. But for between the different sheets i am getting Error (Err.No: 509 : "Operator Missing").

Kindly Help Me On This... ! Thankyou in advance. :)

Solution

Given the difference in the expressions shown in the comments you are missing the exclamation marks "!" (you have "." which is not the same) which tell excel it is not on the current sheet. Mark's version is correct.

Answered By - Solar Mike

Answer Checked By - Clifford M. (PHPFixing Volunteer)