Syntax Again...
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...
--
|