Skip to Content
author's profile photo
Former Member

Sumproduct problems in Xcelsius???

Post Author: gmatriix

CA Forum: Xcelsius and Live Office

Hello All,

Can anyone tell me why a supported function (sumproduct) gives me a #Value! error when I preview the dashboard. I works fine in excel. the formula I am trying to use is:

=IF(OR(B18="",C18="",D18=""),"",SUMPRODUCT(('Query Data'!J2:J5000=Calculations!B18),('Query Data'!K2:K5000=Calculations!C18),--('Query Data'!M2:M5000=Calculations!D18),'Query Data'!N2:N5000))

I don't understand why it is not excepting this supported formula........?????

Any Ideas??????

Thanks

gmatriix

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on Jan 06, 2008 at 07:57 AM

    Post Author: amr_foci

    CA Forum: Xcelsius and Live Office

    note that not all the Excel functions supported by Xcelsius

    please check http://infomps.tempdomainname.com/help/xcelsiusHelpXLV4/source/ref_tool_xlfuncs.htm

    and check this for more information about xcelsius

    http://infomps.tempdomainname.com/help/xcelsiusHelpXLV4/source/ug_FAQPro.htm

    good luck

    Amr

    Add comment
    10|10000 characters needed characters exceeded