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