undefinedCould someone help me. I want to add numbers in a column C but
only if column F has dates in. Can this be done?
c d e
f

89 5/17/2005 22-May
56 5/18/2005 23-May
93 5/19/2005 24-May
100 5/20/2005 25-May
26 5/21/2005 26-May
2567 5/22/2005 27-May
1002 5/23/2005 28-May
678 5/24/2005
123 5/25/2005
89 5/26/2005
56 5/27/2005
45 5/28/2005
39 5/29/2005
82 5/30/2005
152 5/31/2005
168 6/1/2005
155 6/2/2005
1359 6/3/2005

total 6879 0
it


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

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

=sumif(c1:c100,"0",f1:f100)

"mamoo2" wrote in
message ...

undefinedCould someone help me. I want to add numbers in a column C but
only if column F has dates in. Can this be done?
c d e
f

89 5/17/2005 22-May
56 5/18/2005 23-May
93 5/19/2005 24-May
100 5/20/2005 25-May
26 5/21/2005 26-May
2567 5/22/2005 27-May
1002 5/23/2005 28-May
678 5/24/2005
123 5/25/2005
89 5/26/2005
56 5/27/2005
45 5/28/2005
39 5/29/2005
82 5/30/2005
152 5/31/2005
168 6/1/2005
155 6/2/2005
1359 6/3/2005

total 6879 0
it


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

Thanks it worked beautifully. I was so excited.


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