Hi All,
I am trying to get a cell populated with SUMPRODUCT since I thought it was supported but didnt know if the syntax I am using should work with xcelsius as the value displays correctly in the developer mode but not in preview.
Following is the syntax I am using
=SUMPRODUCT((Sheet2!A2:A6=2009)*(Sheet2!B2:B6=1001),Sheet2!C2:C6)
Using a grid to display the value of the calculated cell, it shows as #value!
What other options are there to use when I want to achieve something similar to a pivot table functionality.
Thanks and regards,
Kaushal.