Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
function to return day in the form "Monday", "Tuesday" etc given . | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |