Skip to Content
0
Former Member
Jun 29, 2009 at 01:13 AM

SUMPRODUCT usage with xcelsius

49 Views

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.