Hey Gang;
I am working on a spreadsheet of sales figures throughout the month. Information is logged stating the date of sale, the source of the contact (newspaper ad, website, etc.) and the amount. I created formulas to count the number of jobs by source for the whole month and also the amount of sales for each source. I need to break that down even further by showing week ending results by source. In the attached file, O4, Q4, S4 and U4 have the week ending date and column L contains the list of sources. I was able to write a formula to sum the number of jobs for each source based on matching the source code and date range. I am hoping some one can help me with a formula that will sum the sales amount if the source code and the date range are met.
FYI: the date range of 4/3 would include the 1st through and including the 3rd. 4/10 would be the 4th, 5th, 6th, 7th, 8th, 9th and 10th and so on.
