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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Why is Access VBA syntax different from Excel syntax?	cr113	Excel Programming	2	December 2nd 09 12:42 AM
The NOW() syntax	Tom	Excel Discussion (Misc queries)	3	January 4th 08 04:10 PM
Syntax	[email protected]	Excel Programming	2	June 22nd 07 04:13 PM
AND if syntax	Janis	Excel Programming	3	September 22nd 06 09:51 PM
Need syntax help!	FCC[_6_]	Excel Programming	6	June 30th 06 10:30 AM

All times are GMT +1. The time now is 01:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us