Return-Path: X-Original-To: apmail-openoffice-users-de-archive@www.apache.org Delivered-To: apmail-openoffice-users-de-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 6940C1807B for ; Sun, 21 Jun 2015 10:35:05 +0000 (UTC) Received: (qmail 73754 invoked by uid 500); 21 Jun 2015 10:35:00 -0000 Delivered-To: apmail-openoffice-users-de-archive@openoffice.apache.org Received: (qmail 73718 invoked by uid 500); 21 Jun 2015 10:35:00 -0000 Mailing-List: contact users-de-help@openoffice.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users-de@openoffice.apache.org Delivered-To: mailing list users-de@openoffice.apache.org Received: (qmail 73707 invoked by uid 99); 21 Jun 2015 10:35:00 -0000 Received: from Unknown (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 21 Jun 2015 10:35:00 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id A518EC0637 for ; Sun, 21 Jun 2015 10:34:59 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0 X-Spam-Level: X-Spam-Status: No, score=0 tagged_above=-999 required=6.31 tests=[SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id imrnxuxIuCYc for ; Sun, 21 Jun 2015 10:34:51 +0000 (UTC) Received: from ngcobalt10.manitu.net (ngcobalt10.manitu.net [217.11.48.110]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTPS id 6839B4741F for ; Sun, 21 Jun 2015 10:34:51 +0000 (UTC) Received: from Esprimo7935 (tmo-103-38.customers.d1-online.com [80.187.103.38]) (Authenticated sender: xjs01) by ngcobalt10.manitu.net (Postfix) with ESMTPSA id D4EB31C89855 for ; Sun, 21 Jun 2015 12:34:44 +0200 (CEST) From: =?iso-8859-1?Q?J=F6rg_Schmidt?= To: References: <5581E298.7050105@web.de> <5585C61E.6060702@jrsch.de> In-Reply-To: Subject: Re: mein Problem Date: Sun, 21 Jun 2015 12:34:42 +0200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook 11 Thread-Index: AdCsC4M6n8IOppC4Q/WL8I9rHXM7JwAAb3Ug X-MimeOLE: Produced By Microsoft MimeOLE V6.1.7601.17609 Hallo,=20 > From: Holger Schulz [mailto:qdl@gmx.net]=20 > Am 2015-06-20 um 21:59 schrieb technik : >=20 > > Vor allem > >=20 > > =3DSUMME(Bewerter1.G102:Bewerter8.G102) >=20 > Hier w=FCrde mich interessieren, ob Calc die Bl=E4tter, aus denen=20 > zu addieren ist, nach Namen interpoliert oder nach der=20 > Reihenfolge, in der sie angeordnet sind. Nach Reihenfolge, ich habe es gerade ausprobiert. Mit Blick auf obige Formel gilt also: Bennenne ich das Blatt "Bewerter8" in "xxx1" um passt sich die Formel an = zu "=3DSUMME(Bewerter1.G102:xxx1.G102)" und funktioniert wie gehabt. Verschiebe ich hingegen das Blatt "Bewerter7" nach rechts hinter Blatt = "Bewerter8" so wird "Bewerter7" nicht mehr in die Summe einbezogen. Gru=DF J=F6rg --------------------------------------------------------------------- To unsubscribe, e-mail: users-de-unsubscribe@openoffice.apache.org For additional commands, e-mail: users-de-help@openoffice.apache.org