Hi,
I went through few documents and found that sumproduct() works in XC 2008.
I’m using XC 2008 SP 4 (Version - 5.4.0.0 and build number - 12,4,0,1166), but when I generate the XLF using sumproduct(), I don’t see any values in the cell. It returns #Value error.
=SUMPRODUCT(($B$16:$N$16>=$D$6) * ($B$16:$N$16<=$D$5),B19:N19)
Any suggestions please…?
selvaips (BOB member since 2005-05-03)
sum product does work in its simplist form. You are combining two arrays however. This is too complex for a SWF file.
The solution to your problem is to do complex array calcuations at the Database level.
Alternatively, you can break down your complex functions into simple steps across different worksheets, where worksheet B uses the results of worksheet B. This will force separate calculations. SumProduct can broken down into simpler functions easily. Doing a bunch of work in Excel is also misusing this software, however.
Cairmor 
(BOB member since 2008-06-05)
Yes Cairmor. I did checked the release notes of XC 2008 SP4, and it’s mentioned that Xcelsius doesn’t support this form of calculation.
the requirement has been achieved using if and vlookup functions, and i’m good. Thank you for taking time to reply. Appreciate it.
selvaips (BOB member since 2005-05-03)