CALCULATION IN ARRAY FORMULA

[Manish Gurve]

Dear All

 

I have received a file (attached)which contains an array formula given below;

 

=SUM(IF('SAP GL'!$A:$A='Daily Collection Report'!$B$6,IF('SAP GL'!$B:$B='Daily Collection Report'!$A8,IF('SAP GL'!$I:$I='Daily Collection Report'!$B$5,'SAP GL'!$H:$H,0))))

 

Whenever I save this file it gives #NUM! error.  How to recover actual values. Do I need to change some config or what.

 

Tried to hit ctrl+shift+enter but not working. Pls help.

 

Regards

Manish Gurve

--
You received this message because you are subscribed to the Google Groups "ExcelFiles_India" group.
To post to this group, send email to excelfil...@googlegroups.com.
To unsubscribe from this group, send email to excelfiles_ind...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/excelfiles_india?hl=en.