I am trying to create a formula to sum the values in a column based on a number of criteria and cannot seem to find an answer for it. I have attached the spreadsheet for reference. I am trying to have excel sum the data in row 4 of columns F through M (individually by column) if the Status (Column E) is not marked as "Done" and the Date (Column A) is in the past or within the next upcoming two weeks. (Example, if today is 4/11/13, I would want it to total anything with an earlier date and anything up to 4/25/13).
I have a formula in place now that totals if it is not marked as "Done" and has a Date, although I cannot figure out how to make it add with the date range I specified. Any help is greatly appreciated!
Bookmarks