Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 72378200C57 for ; Sat, 15 Apr 2017 23:15:49 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 70CA8160BA0; Sat, 15 Apr 2017 21:15:49 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id B956D160B8B for ; Sat, 15 Apr 2017 23:15:48 +0200 (CEST) Received: (qmail 23332 invoked by uid 500); 15 Apr 2017 21:15:47 -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 23318 invoked by uid 99); 15 Apr 2017 21:15:45 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 15 Apr 2017 21:15:45 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 76BDD1A0011 for ; Sat, 15 Apr 2017 21:15:45 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.379 X-Spam-Level: ** X-Spam-Status: No, score=2.379 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, KAM_NUMSUBJECT=0.5, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id uT4uNwoQ5Q-3 for ; Sat, 15 Apr 2017 21:15:44 +0000 (UTC) Received: from mail-yw0-f178.google.com (mail-yw0-f178.google.com [209.85.161.178]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id B978D5F343 for ; Sat, 15 Apr 2017 21:15:43 +0000 (UTC) Received: by mail-yw0-f178.google.com with SMTP id u70so2944793ywe.2 for ; Sat, 15 Apr 2017 14:15:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=ZXo3pcHTuWslK52KWB9VZlo3xNzBsaC5q+26izRxQsU=; b=daC76HP319hOBtNpuT2bjEIKKYTIhKIhSHbMPudC2lY9nZX8NhSnhiVVh/coY1fMY/ S5FddbxH3uUCvI2gSQjOcyr/qTPr/hn4VelGT+gPdZ0knzDz8jQSdcYaNDVCjC/59/LO Nh85EatzQfwJut8yDh8eskVcYL6R5vl7kBpENQ38+GQwfIWEfl390gnJGYyN1+HFU0Qt lzZ7CMfEcy26RAjXULbMNmo6l3dbJhtMDDa/fhyURVXGbRA9mhkkVrLFsjCKGvescKcV lDV0Sb4wvHAVlj5AiuiIA01ZvKPqE9cvrvNHVgIaE2lPnoLdOIhixMqvMiHsLKt+qfjZ T7XA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=ZXo3pcHTuWslK52KWB9VZlo3xNzBsaC5q+26izRxQsU=; b=Y0byBdLSvVTvaH5H6ico3AXL+xLLYaduPpNAbkxLAdWcGidtCXhto3AJreVMslpNVy mbOt1PcbMAIIBbF1XIeo81hUHdMiA12MGGRiYOkpLo5uJ+G+i+u/oAXe/f7olHLQwDaR gTmaG6UPLmQ5lrhYqQ1F/0YLyixIqG878m/Xw/iX60cSL/Cd+S325JiZ5l+SyscuXOg/ cg47av5lHOC7GXhr8SNj/YUScF/3ybefPesU/8MIdhxHqDQyXJ8GTrPmNTej7QfxxB34 4+7Z6hiZ8rHZVDsCadCR/yAyZLGfkstjpOT1oWq4R4nQvQ6/JlpyhqZM/OLu8rEeD4Ef lALQ== X-Gm-Message-State: AN3rC/5T09UVv1QGCjqcrm7eQYLU0/rBLzfLJDro118kahxr7EpWrRn4 tuShX0tyihy6zbIC+9DEHwqlue9Cv/TC X-Received: by 10.129.131.193 with SMTP id t184mr10584807ywf.317.1492290937139; Sat, 15 Apr 2017 14:15:37 -0700 (PDT) MIME-Version: 1.0 Received: by 10.129.46.193 with HTTP; Sat, 15 Apr 2017 14:15:16 -0700 (PDT) From: Michael Grimm Date: Sat, 15 Apr 2017 23:15:16 +0200 Message-ID: Subject: Open Office Calc 4.1.3 To: users-de@openoffice.apache.org Content-Type: multipart/alternative; boundary=001a114ec83a35b7ab054d3b0f4b archived-at: Sat, 15 Apr 2017 21:15:49 -0000 --001a114ec83a35b7ab054d3b0f4b Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Liebe Mitanwender, ich habe eine tagesbezogene Erl=C3=B6sstatistik nach Kunden erstellt. Aus d= ieser soll eine Summenliste nach Kunden und Monaten gef=C3=BCttert werden. F=C3= =BCr das aktuelle Jahr 2017 funktioniert das. Dies ist z.B. die Funktion, um den Januar 2017 f=C3=BCr einen Kunden zu saldieren. =3DSUMMEWENNS(Unterrichtstage_2016_.$J$4:$J$402;Unterrichtstage_2016_.$D$4:= $D$402;A5;Unterrichtstage_2016_.$B$4:$B$402;"<=3D31.Jan") Wenn ich jetzt diese Summenliste f=C3=BCr 2016 erstellen will, muss ich sta= tt 31.Jan was angeben, damit ein Vergleich auf den 31.01.2016 erfolgt? ich habe versuchsweise das Datum 31.01.2016 in eine Zelle gepackt und statt 31. Jan die Zelle angegeben. Da wird aber nichts saldiert. Was kann ich tun? Vielen Dank schon mal f=C3=BCr die Unterst=C3=BCtzung. Michael Grimm --001a114ec83a35b7ab054d3b0f4b--