DATE(2020,2,18)
What's wrong with
=SUMIF(G1:G10,">DATE(2020,2,18)",J1:J10)
Returns 0, no error
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?
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (2 / 14) |
Uptime: | 72:28:22 |
Calls: | 6,657 |
Calls today: | 3 |
Files: | 12,203 |
Messages: | 5,332,304 |
Posted today: | 1 |