| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 -- |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Syntax Again...
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... -- |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Syntax Again...
Hi Duane.
Am Wed, 7 Oct 2020 06:55:32 -0500 schrieb dpb: That documented anywhere, Claus? I didn't see it anywhere. You don't need the ampersand if you insert the date as string: Use: =SUMIF(G1:G10,""&DATE(2020,2,18),J1:J10) or =SUMIF(G1:G10,"18.02.2020",J1:J10) Regards Claus B. -- Windows10 Office 2016 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is Access VBA syntax different from Excel syntax? | Excel Programming | |||
| The NOW() syntax | Excel Discussion (Misc queries) | |||
| Syntax | Excel Programming | |||
| AND if syntax | Excel Programming | |||
| Need syntax help! | Excel Programming | |||
Hybrid Mode
