Try this:

=SUMIF(B:B,"="&F2,C:C)


--
Biff
Microsoft Excel MVP


"Sherry N." wrote in message
...
Hello,
I have a worksheet that gets data from external source. I need to sum
numbers in Column C if date in Column B is = another cell.

I tried:
=IF(B:B=F2,SUM(C:C))
=SUMIF(B:B,B:B=F2,C:C)

Much appreciated.
--
Sherry N.