Hmmmm.....I had been changing around the parentheses for an age without any
luck, so I came to the conclusion that the problem was something else! Im
embarassed that its working now!! I guess after hours on front of the screen
I simply had a brain freeze! Oh well, thanks Chip. Best regards from Ireland.
:-)

L8rs.

"Chip Pearson" wrote:


,SUM(Wood!Y13)*(Wood!M13))
should be either
, SUM((Wood!Y13)*(Wood!M13))
or
, SUM (Wood!Y13*Wood!M13)

You have either a missing open or missing close paren in this last piece.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)