I have a workbook that I list assignments, and each of these assignments have a dollar value associated with them. I want to create a summary of those dollar values based on the month the assignments were taken. Basically a monthly total for each month with the total dollar value. The dates are in column C of the spreadsheet, and the dollar value associated with the assignment is in column G. Now for assignments that are NOT completed as of yet, column C would contain either the word "printed" or the default of "1/0/1900" since the dates are linked fromanother worksheet.
In addition to having a monthly total (jan, Febm etc....), I would also like to be able to have a weekly total for this very same information. I have tried using the SUMIF function, but I have not been able to get it to work for my needs, the "value" always returns a "0" instead of the proper value.