Closed Thread
Results 1 to 2 of 2

Summing Data by Week Ending and Category

  1. #1
    Registered User
    Join Date
    09-18-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    46

    Summing Data by Week Ending and Category

    Hello! I am trying to put together a budget worksheet that will take my weekly budgeted amounts by category and compare them to my actual spent amounts according to what is entered into a register on another sheet. I have gotten everything to work except for the field where it would look at the register and pull all transactions for that date within only a given category and insert them into my budget sheet. On the attached example, I would want to put a formula into field D2 of the "Budget" page that would return a total of $2916.73. The same formula in D3 would return a total of $209.26 and so on.

    Please help! I've been driving myself crazy trying to figure this one out...Attachment 268781

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Summing Data by Week Ending and Category

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    http://www.excelforum.com/excel-gene...-category.html

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sheets for every week + start and ending date of the week
    By wimexcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-30-2012, 01:48 PM
  2. Replies: 10
    Last Post: 03-01-2011, 08:46 AM
  3. OT #4 -- week ending Sun 03-Jan-10
    By teylyn in forum The Water Cooler
    Replies: 1
    Last Post: 12-28-2009, 11:41 AM
  4. OT #1 -- week ending Sun 13-Dec-09
    By teylyn in forum The Water Cooler
    Replies: 42
    Last Post: 12-12-2009, 03:43 PM
  5. Summing Data based on Its Category
    By sip8316 in forum Excel General
    Replies: 2
    Last Post: 05-24-2005, 03:06 PM

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