col CC is a list of dates (ie 09/12/2005 & 10/13/2005). Col CF contains
dollar amounts. I want to make a formula that adds col. CF taking only
dollars on lines that have a September date and put the result in CF22. This
is the formula I came up with but it doesn't work:
=SUMIF(CC7:CC20,"=<(date)09/30/2005,=09/01/2005",CF7:CF20) The formula gives
me $0.00 and it should be $150.00. Can any one help me correct my mistake
please?
--
D. W. Cameron