+ Reply to Thread
Results 1 to 7 of 7

YTD totals based on Whether or not data has been entered in a column

  1. #1
    Registered User
    Join Date
    10-11-2019
    Location
    Milwaukee, wi
    MS-Off Ver
    pro
    Posts
    4

    YTD totals based on Whether or not data has been entered in a column

    I am attempting to build a work book that calculates YTD totals based on whether or not a cell has been filled in.
    For the example, the entire year's monthly budget would be filled in. The actual expenses would be filled in at month's end when everything is finalized.
    For the YTD figure I would like to calculate the budgeted total for only the months that the actual expenses have a value (including 0).
    Is this possible? I haven't seen an equation in any of the forums related to this.

    Thanks kindly for any help anyone can provide.

    Mike
    Attached Files Attached Files

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,372

    Re: YTD totals based on Whether or not data has been entered in a column

    Do you mean:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    ??
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    10-11-2019
    Location
    Milwaukee, wi
    MS-Off Ver
    pro
    Posts
    4
    Quote Originally Posted by xladept View Post
    Do you mean:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    ??
    I am looking for seperat totals year to date for budget, actual and variance. I only want the budget and variance to add in the months that have actual totals.

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,580

    Re: YTD totals based on Whether or not data has been entered in a column

    Try this in cell AL3. Fill down and across column AN
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  5. #5
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    5,439

    Re: YTD totals based on Whether or not data has been entered in a column

    Al3:
    Please Login or Register  to view this content.
    am3:
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    10-11-2019
    Location
    Milwaukee, wi
    MS-Off Ver
    pro
    Posts
    4

    Re: YTD totals based on Whether or not data has been entered in a column

    That worked perfectly! Thanks so much for the assistance!

  7. #7
    Registered User
    Join Date
    10-11-2019
    Location
    Milwaukee, wi
    MS-Off Ver
    pro
    Posts
    4

    Re: YTD totals based on Whether or not data has been entered in a column

    What if I wanted to do the same equation, but not sum when the actual = 0?

    Thanks again!

+ 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. Replies: 4
    Last Post: 02-10-2019, 04:36 PM
  2. [SOLVED] Formula Needed to count data in a column based on certain data entered into another
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-08-2017, 11:56 PM
  3. [SOLVED] if data is entered in column A, column B should have date automatically entered.
    By exceltriumph in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-30-2016, 12:02 PM
  4. [SOLVED] Conditional formatting to change colors of Columns based on data entered in Column E
    By JJFletcher in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-13-2016, 01:27 PM
  5. Replies: 3
    Last Post: 05-17-2013, 10:04 AM
  6. Auto Populate Two Columns Based On Data Entered Into Another Column
    By aleenah in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2013, 08:37 PM
  7. Formula that subtracts from multiple totals based on date first entered
    By jcroft11 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-26-2012, 01:17 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