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

Try...

=SUMPRODUCT(--(CC7:CC20-DAY(CC7:CC20)+1=A1),CF7:CF20)

....where A1 contains the first day of the month for the month of
interest. For example, for the month of September, you would enter
9/1/2005 in A1.

Hope this helps!

In article ,
"Wayne Cameron" wrote:

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?