"Too many arguements for this function".....ohh nooo....
 

Hi all,
I typed in the following function:

=IF(Wood!I9="y",SUM(Wood!Y13)*(Wood!I13),IF(Wood!K 9="y",SUM(Wood!Y13)*(Wood!K13)),IF(Wood!M9="y",SUM (Wood!Y13)*(Wood!M13))

All was fine until I typed in the bit at the end:
,SUM(Wood!Y13)*(Wood!M13))

and I was told I had too many arguements for this function..... I hadn't
even finished my arguements!!

Anyway, I need to write the above, but I need to extend it on from I9,K9 &
M9 as above, to also include O9, Q9, and S9 aswell. I think I might need an
array formula, but I haven't figured them out enough yet to write one myself.
:-(

The cells in question (I9,K9,M9 etc) are blank and if the user puts in a
letter 'y' in any of these cells, then the function has to multiply that
column's cell number 13 (I13,K13,M13 etc) by the value in Y13. I then want to
be able to copy this formula down to keep the I9,K9,M9...(For the 'y' input)
etc the same, but change the row to be multiplied from 13 to 14,15,16,17...
etc

Please help.....

"Too many arguements for this function".....ohh nooo....
 

,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)



"dim" wrote in message
...
Hi all,
I typed in the following function:

=IF(Wood!I9="y",SUM(Wood!Y13)*(Wood!I13),IF(Wood!K 9="y",SUM(Wood!Y13)*(Wood!K13)),IF(Wood!M9="y",SUM (Wood!Y13)*(Wood!M13))

All was fine until I typed in the bit at the end:
,SUM(Wood!Y13)*(Wood!M13))

and I was told I had too many arguements for this function..... I hadn't
even finished my arguements!!

Anyway, I need to write the above, but I need to extend it on from I9,K9 &
M9 as above, to also include O9, Q9, and S9 aswell. I think I might need
an
array formula, but I haven't figured them out enough yet to write one
myself.
:-(

The cells in question (I9,K9,M9 etc) are blank and if the user puts in a
letter 'y' in any of these cells, then the function has to multiply that
column's cell number 13 (I13,K13,M13 etc) by the value in Y13. I then want
to
be able to copy this formula down to keep the I9,K9,M9...(For the 'y'
input)
etc the same, but change the row to be multiplied from 13 to
14,15,16,17...
etc

Please help.....

"Too many arguements for this function".....ohh nooo....
 

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)