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)