Sum based on date

[Sherry N.]

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.

 

[T. Valko]

Try this:

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

 

[Sherry N.]

PERFECT! Thanks a million!
--
Sherry N.

Try this:

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

 

[T. Valko]

You're welcome. Thanks for the feedback!