+ Reply to Thread
Results 1 to 3 of 3

Sum Formula That Ignores Column Headers That Are Dates

  1. #1
    Forum Contributor
    Join Date
    04-27-2009
    Location
    Dallas, TX
    MS-Off Ver
    Office 365
    Posts
    215

    Sum Formula That Ignores Column Headers That Are Dates

    I like to use formatted dates as column headers. But when I sum the column and ignore the column header that is in date format, the sum formula gives me a warning flag.

    Is there a way to stop this?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Sum Formula That Ignores Column Headers That Are Dates

    No idea what you are trying to describe. What column(s)? What formula? What warning flag?

    Post a sample workbook. See the yellow banner at the top of the page.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Re: Sum Formula That Ignores Column Headers That Are Dates

    If you mean you have dates like 2 Mar 2021 in, say row 3, nothing in rows 1 and 2, and numeric values in row 4 down, and you're using formulas like =SUM(X:X) or more likely =SUM(X:X)-X3, then you're intentionally doing something suboptimal.

    You could suppress error indicators generally, but that's a bad idea. You could live with them too, accepting that what you're doing has the unavoidable consequence of displaying such indicators. Or you could avoid such constructs and use formulas like =SUM(X4:X1000), which would be better in all ways except convenience and would certainly remove the error indicators unless there were something amiss from row 4 down.

+ 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] Need Formula to post payments with different dates frequency than Column Headers
    By caabdul in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-03-2020, 03:46 PM
  2. Sum up data in rows based on dates in column headers - PowerPivot
    By KonRAD9 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-21-2019, 09:04 PM
  3. Sumifs formula that ignores text and blanks in the criteria column
    By sjs4952 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-30-2018, 02:48 AM
  4. [SOLVED] Dynamic Range in Column Chart That Ignores Blank and With-Formula Cells
    By ykobure in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-26-2015, 08:57 AM
  5. [SOLVED] Summary by Month Using Dates in Column Headers
    By glennchung in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-18-2014, 01:19 PM
  6. [SOLVED] Due dates formula in conditional formatting that ignores blanks
    By ciapul12 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-31-2013, 08:48 AM
  7. Replies: 2
    Last Post: 07-11-2012, 08:58 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