+ Reply to Thread
Results 1 to 5 of 5

Function for adding certain random cells

  1. #1
    Registered User
    Join Date
    12-03-2013
    Location
    NE AR
    MS-Off Ver
    Excel 2010
    Posts
    4

    Function for adding certain random cells

    I have an expense handbook that I track my expenses and incomes. In the book I use certain codes for various expenses such as fuel, breakdowns and utilities. They vary month to month, so there's no set amount of each expense I will have for any particular month; as well as what order they would be written. I write them down as they are expensed. Is there a way to enter an expense with a code independently and have it total into another cell for a total spent for that expense for that month?

  2. #2
    Registered User
    Join Date
    12-03-2013
    Location
    NE AR
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Function for adding certain random cells

    Here's a copy of the first page. I plan on doing 12 sheets, one for each month. I will also do a yearly total at the end that will automatically pull each total from the right columns for a budget review.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-03-2013
    Location
    NE AR
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Function for adding certain random cells

    No one has any ideas?

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Function for adding certain random cells

    You could get rid of columns H:I and use a pivot table directly from columns. Mingle expenses and income in the same list with different signs.

    Or buy Quicken.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    12-03-2013
    Location
    NE AR
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Function for adding certain random cells

    I bought quicken. It worked fine for 7 months then wouldn't download info from bank. So I created a new file, but it would only download back to April. This is so much simpler.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Adding two cells containing SUM function adding up to zero
    By ra3940 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-18-2012, 01:28 PM
  2. Random numbers adding up
    By chv1403 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-03-2011, 06:28 AM
  3. Adding time values for no sequence cells with an IF function
    By Khaldon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2011, 04:00 AM
  4. Replies: 2
    Last Post: 12-07-2010, 04:29 PM
  5. Help with adding certain cells using an IF function
    By Jrr6415sun in forum Excel Formulas & Functions
    Replies: 28
    Last Post: 09-06-2005, 03:05 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