@Ep45cal. Excuse me very much. By @Debaser comment, I understood that I accidentally have attached the wrong file. The correct file is current attachment.(the edit option was not available to modify the original question).
. If you click on sheet2!A1 you can see the problem. Its references are correct and when first written It gave me the correct answer but when I clicked on it its result unexpectedly changed to 0zero.
|