View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sherry N. Sherry N. is offline
external usenet poster
 
Posts: 15
Default Sum based on date

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.