if ???

[mamoo2]

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

[Ron Coderre]

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

[N Harkawat]

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

"mamoo2" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[mamoo2]

Thanks it worked beautifully. I was so excited.