Results 1 to 6 of 6

If any cell in column B contains X, take number from column C in same row and add them up.

Threaded View

BurtMacklin If any cell in column B... 10-23-2013, 05:29 PM
jindon Re: If any cell in column B... 10-23-2013, 07:46 PM
AlphaFrog Re: If any cell in column B... 10-23-2013, 07:56 PM
Leith Ross Re: If any cell in column B... 10-23-2013, 08:18 PM
BurtMacklin Re: If any cell in column B... 10-23-2013, 08:40 PM
jindon Re: If any cell in column B... 10-23-2013, 09:13 PM
  1. #1
    Registered User
    Join Date
    10-23-2013
    Location
    Madison, WI
    MS-Off Ver
    Excel 2013
    Posts
    2

    If any cell in column B contains X, take number from column C in same row and add them up.

    Hey folks,
    I am putting together a personal expense spreadsheet and need help with this one part.

    On one sheet I have all my debits listed, date-category-price. On a second sheet I have the totals for each category for that month. Each month will have its own sheet.
    I want to take all the debits from a certain month and combine them with their respective category be shown on the given month's sheet.

    I want the equation to automatically filter out any entries outside of the target month so that I will be able to select the column as opposed to selecting the specific cells within the month.
    This will make for a more automated and "live updating" system since I wont have to change the selected cells every time I enter a new debit.

    I have attached a simple example of what I am looking for.

    Thank you so very much for you help, I really appreciate it!!!
    Attached Files Attached Files
    Last edited by BurtMacklin; 10-23-2013 at 05:35 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 13
    Last Post: 09-19-2013, 06:54 PM
  2. Replies: 4
    Last Post: 05-26-2013, 05:54 PM
  3. Replies: 7
    Last Post: 10-23-2012, 02:29 PM
  4. Replies: 8
    Last Post: 09-16-2012, 02:13 PM
  5. Replies: 10
    Last Post: 07-12-2010, 08:55 AM

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