add column using dates as argument
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 |
add column using dates as argument
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? |
All times are GMT +1. The time now is 12:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com