Take the second right peren ) and move it to the end of your formula so, =sum(table a::(B7:B9)x1.04)
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jürgen Fleger Sent: Friday, March 13, 2015 13:58 To: Mac Visionaries Visionaries Subject: Numbers: referencing to cells and multiply them 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.
