Hi Phil, thanks, you made my day. :-) It worked perfectly well. You might be able to teach me something else: When I use the formular editor to take its suggestions for ranges, strange things apeared. I used the arrow keys to walk through it. It read content of cells but also numbers like 2:2, 3:3, 4:4 and so forth. I didn’t get what it meant. Could you help me to understand? And: I defined the range b7 to b9 to be in the formular. What if I want to add later cell b10 as well? Do I have to change the complete formular or is there a way to define a range in a formular more openly?
Thanks and all the best Jürgen > Am 13.03.2015 um 23:02 schrieb Phil Halton <[email protected]>: > > 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. -- 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.
