Thread
:
Sum based on date
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Sherry N.
external usenet poster
Posts: 15
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.
Reply With Quote
Sherry N.
View Public Profile
Find all posts by Sherry N.