Thread: Syntax Again...
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dpb dpb is offline
external usenet poster
 
Posts: 109
Default Syntax Again...

What's wrong with

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

Returns 0, no error

=G1DATE(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

--