Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2009
    Posts
    212
    Thanks
    36
    Thanked 0 Times in 0 Posts

    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.
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    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. #3
    3 Star Lounger
    Join Date
    Dec 2009
    Posts
    212
    Thanks
    36
    Thanked 0 Times in 0 Posts
    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
  •