cost by date, this issue makes no sense

Topic

New Reply

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.

Reply | Quote

Replies

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

Reply | Quote

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.

Reply | Quote