On Mon, 24 Nov 2008 13:15:01 -0800, AnotherNewGuy
wrote:

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).

Without regard to what might be in E:E if there is no date, and since you write
that your current SUMIF formula works correctly, you could use this:

=sum(c:c)-SUMIF(E:E,"" & DATEVALUE("1/1/1980"),C:C )

--ron