See if this works for you:

=SUMIF(F1:F10,"<"&"",C1)

Change the references to suit your situation.

Note: My assumption is that column F will only contain dates or
nothing. Any value in column F will cause the corresponding value in
column C to be included in the total.

Does that help?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=375698