Thread
:
Syntax Again...
View Single Post
#
1
Posted to microsoft.public.excel.misc
dpb
external usenet poster
Posts: 109
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
--
Reply With Quote
dpb
View Public Profile
Find all posts by dpb