Summing values for a particular date range and putting into one cell.

[Catherine01]

I have a column of dates that span many years. Each of the dates has a corresponding amount of money that was spent on that day. I need a formula that will take only a certain year (or part of a year) and then sum the amount of money spent only on those days and put that value into one cell.

I have tried sum, sumif, ......and all sorts of formulas.

Any suggestions for this one? Do you need to know more?

Thanks in advance.

[FDibbins]

you tried sumif(), but did you try sumifS()?

sumifS() allows for multiple criteria, give it a shot and let me know how you make out?

[Catherine01]

Okay, so when I started a whole new worksheet and put in some examples, it worked easily and perfectly. I attached the example but basically I came up with this formula:

=SUMIFS($D$2:$D$28,$B$2:$B$28,"<=12/31/2007",$B$2:$B$28,">=1/1/2007") for the amount of money spent in 2007,

=SUMIFS($D$2:$D$28,$B$2:$B$28,"<=12/31/2008",$B$2:$B$28,">=1/1/2008") for the amount of money spent in 2008, and

=SUMIFS($D$2:$D$28,$B$2:$B$28,">=07/1/2008",$B$2:$B$28,"<=1/31/2009") for the amount of money between July, 2008 and January, 2009 (including those months.)

So, my problem now is this:
Why won't that work in my original spreadsheet? I'll tell you why: because of some formatting problem, that's why! I spent hours on this formula, put in a DATE, DATE RANGE, ...all sorts, but I've come to believe that it is just because somewhere in the data I cannot tell the format. Not just simple stuff, but rather, if there is data validation, or formatted so that some of the values disappear (like for example, (0;-0;;@), or if one cell is using another's answer and I can't tell because nothing shows up when I try to see if there are any precedents or dependents on those cells, or even if I copy a cell or column and then paste it incorrectly so that the value..............know what? My question has changed to how do I clear my formatting or rules, or codes or conditions or validations back to when I opened a new spreadsheet and started working fresh?

[dredwolf]

Select Entire worksheet (click on the right/down pointing triangle, just above the row numberes, and just to the the right of the columns),format cells, number, general,ok; CF, Clear Rules, Entire Sheet, ok;
BUT, neither one will affect the outcome..formatting is only for visual presentation, the underlying value (which is used for any calculations referencing that cell) remains the same...
Your attachment appears to have failed, so can not offer any specific explanation or solution to your problem