try =sum(Table A::b7:b9)*0.4 put this formula in the table B cell. Make sure you get the table name exact. the formula editor will suggest the table name after you type a few letters and you can just hit enter when it gets the right table name, then just continue typing your formula. The problem you are having is with the set of parenthesis that begins after the table name. that’s a syntax error because you were typing it in the middle of a data identifier. The sum function parenthesis are all you need here.
> On Mar 13, 2015, at 4:58 PM, Jürgen Fleger <[email protected]> wrote: > > Hi, > > here's something I come not along. Would be great if someone could help me > understand: > > I have a sheet with two tables. Table A and Table B. I want to sum three > cells from table a and multiply it with 0.4. I want the result to apear in > Table b in a specific cell. So I tried several writings for the formular but > nothing worked. Here's something I beleive I came close: > =SUM(Table A::(B7:B9))×0.4 > > Unfortunately it didn't work. Do you have an idea what could be more > successful? > > Thanks and > all the best > Jürgen > > -- > You received this message because you are subscribed to the Google Groups > "MacVisionaries" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/macvisionaries. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
