+ Reply to Thread
Results 1 to 2 of 2

Data's and Expense Totaling

  1. #1
    Registered User
    Join Date
    03-09-2008
    Posts
    1

    Data's and Expense Totaling

    Hello Folk,

    I have been picking my minds for a few days. I tried using conditional Sum.

    ex.

    Date Type Tax Total
    02/05/2008 Gas .12 10.00
    02/09/2008 Books .14 12.00
    03/10/2008 Food .10 1.00
    03/18/2008 Tickets .12 3.00
    03/19/2008 Gas .15 4.00

    i want another page to add total of each month expenses just all of feb, then march, i know i can add each one up, but an on going total . help please. i came up with

    =SUM(IF(Expenses!$A$6:$A$2300>DATEVALUE("2/1/2008"),IF(Expenses!$A$6:$A$2300<"02/30/08",Expenses!$F$6:$F$2300,0),0))

    but, it ends up adding everything together not just the dates btw 02/01/2008 - 02/31/2008

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Maybe like this:
    Please Login or Register  to view this content.
    The formula in G2 and copied down is =SUMPRODUCT( ($A$2:$A$6 >= F2) * ($A$2:$A$6 <= F3) * $D$2:$D$6 )
    Last edited by shg; 03-09-2008 at 10:35 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1