When I run the conditional sum wizard I get a run-time error '1004':

Unable to set the FormulaArray property of the range class

This only happens if I use a different sheet with in the workbook to show
the result in. If I choose an empty cell in the current sheet it works just
fine. Is this a limitation or is there a work-a-round?