# Thread: cost by date, this issue makes no sense

1. ## cost by date, this issue makes no sense

See attached file.
Issue #1
I want to total cost by month. Dec sum is not incuding last Dec entry [Dec 31].

Issue #2
When I try to carry sum over to another sheet [totals], I get a return of "0", even when I use same formula as main sheet [gas expense], which includes reference to sheet.

2. 1) your ranges are not aligned. The criteria and sum do not start in same row. Use either:

=SUMIF('gas expense'!A\$2:A\$8,">"& "12/1/2011",C2:C8)-SUMIF('gas expense'!A\$2:A\$8,">="& "1/1/2012",C2:C8)

or

=SUMIF('gas expense'!A\$3:A\$8,">"& "12/1/2011",C3:C8)-SUMIF('gas expense'!A\$3:A\$8,">="& "1/1/2012",C3:C8)

2) The formula looks at the criteria on the gas expense sheet, but sums the values in the active sheet since you don't have the sheet name listed;Use either:

=SUMIF('gas expense'!A\$2:A\$8,">"& "12/1/2011",'gas expense'!C2:C8)-SUMIF('gas expense'!A\$2:A\$8,">="& "1/1/2012",'gas expense'!C2:C8)

or

=SUMIF('gas expense'!A\$3:A\$8,">"& "12/1/2011",'gas expense'!C3:C8)-SUMIF('gas expense'!A\$3:A\$8,">="& "1/1/2012",'gas expense'!C3:C8)

Steve

3. ## The Following User Says Thank You to sdckapr For This Useful Post:

skipro (2012-01-03)

4. Steve,
Thanks. I do not know which is worse, not knowing how to do it or being careless. Sometimes you cannot see the trees through the forest.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•