Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
55
More Complex Formulas with References
posted

We were thinking about reaplacing the usage of COM Excel object with some of the 3rd party .Net components. I was evaluating several of them and saw that Infragistics component is one of few that uses its own(?) CalcEngine. Hovever it has problems when referencing other sheets and ranges. Is there any way to tweak the CalcEngine to work with formulas like this:

=IF('ALL YLT'!A4<>"";SUMIF('ALL YLT'!$D$3:$Z$3;"STD";'ALL YLT'!D4:Z4)+SUMIF('ALL YLT'!$D$3:$Z$3;"ADH";'ALL YLT'!D4:Z4);"")

 

Code:

Outupt window:

File in Excel

 

Thanks

Parents
No Data
Reply
  • 44743
    posted

    A formula like that should work. I believe a bug fix was made recently which might cause this to work. Can you send me the excel file you used with this code and I will check to see if it works now?

Children