1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.MI

  • Syntax Again...

    From dpb@21:1/5 to All on Tue Oct 6 19:25:56 2020
    What's wrong with

    =SUMIF(G1:G10,">DATE(2020,2,18)",J1:J10)

    Returns 0, no error

    DATE(2020,2,18)

    in K1 returns TRUE/FALSE depending on the value in G1; the values in
    column G are dates, numeric values nonzero in column J

    --

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Claus Busch@21:1/5 to All on Wed Oct 7 09:44:24 2020
    Hi,

    Am Tue, 6 Oct 2020 19:25:56 -0500 schrieb dpb:

    What's wrong with

    =SUMIF(G1:G10,">DATE(2020,2,18)",J1:J10)

    Returns 0, no error

    you must add a function with an ampersand: =SUMIF(G1:G10,">"&DATE(2020,2,18),J1:J10)


    Regards
    Claus B.
    --
    Windows10
    Office 2016

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From dpb@21:1/5 to Claus Busch on Wed Oct 7 06:55:32 2020
    On 10/7/2020 2:44 AM, Claus Busch wrote:
    Hi,

    Am Tue, 6 Oct 2020 19:25:56 -0500 schrieb dpb:

    What's wrong with

    =SUMIF(G1:G10,">DATE(2020,2,18)",J1:J10)

    Returns 0, no error

    you must add a function with an ampersand: =SUMIF(G1:G10,">"&DATE(2020,2,18),J1:J10)


    That documented anywhere, Claus?

    Thanks...

    --

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Claus Busch@21:1/5 to All on Wed Oct 7 15:06:21 2020
    Hi Duane.

    Am Wed, 7 Oct 2020 06:55:32 -0500 schrieb dpb:

    That documented anywhere, Claus?

    I didn't see it anywhere.

    You don't need the ampersand if you insert the date as string:
    Use:
    =SUMIF(G1:G10,">"&DATE(2020,2,18),J1:J10)
    or
    =SUMIF(G1:G10,">18.02.2020",J1:J10)


    Regards
    Claus B.
    --
    Windows10
    Office 2016

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)