Post the formula

--
Biff
Microsoft Excel MVP


"JLP" wrote in message
...
I get the error message 'unable to set the formula array property of the
range class' when I am using a conditional sum function. The data - the
range - is on one worksheet and the result of the calculation is on
another
worksheet. If both the data and the result are on the same worksheet, no
error message. Anyone have any ideas?