Posted to microsoft.public.excel.misc

AnotherNewGuy AnotherNewGuy is offline

external usenet poster

Posts: 44

Sumif() with dates

Column C is a column of number
Column E is a column of dates

I want to sum every number in C with no corresponding date in E. Seems
simple, but . . . .

=SUMIF(E:E,"" & DATEVALUE("1/1/1980"),C:C ) will sum everything with a
date, but I've been unable to figure out how to sum everything without a
date. Replacing the "" with "<" returns zero (0).

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
sumif using dates	txm49	Excel Discussion (Misc queries)	3	October 9th 07 08:11 PM
SUMIF with dates	RHfactor	Excel Worksheet Functions	2	May 30th 07 07:09 PM
SUMIF using Dates	Mike McLellan	Excel Discussion (Misc queries)	3	July 18th 06 08:15 AM
Sumif & Dates	angela	Excel Worksheet Functions	4	May 17th 06 07:30 PM
SUMIF and Dates	Mike	Excel Worksheet Functions	7	December 14th 05 06:16 PM

All times are GMT +1. The time now is 05:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us