+ Reply to Thread
Results 1 to 3 of 3

Summary by Month Using Dates in Column Headers

  1. 12-17-2014, 05:35 PM #1
    glennchung
    glennchung is offline
    Forum Contributor
    Join Date
    01-29-2009
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    123

    Summary by Month Using Dates in Column Headers

    Hi

    I have a data table with dates as column headers and would like to sum by month and category. Please see attached, I need help with formula in the yellow cells. Thank you!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-17-2014, 05:54 PM #2
    popipipo
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: Summary by Month Using Dates in Column Headers

    Maybe this way?
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong
    Reply With QuoteRegister To Reply
  3. 12-18-2014, 01:19 PM #3
    glennchung
    glennchung is offline
    Forum Contributor
    Join Date
    01-29-2009
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    123

    Re: Summary by Month Using Dates in Column Headers

    Thank you very much!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] listbox with column headers as a specific sheet column headers
    By ANDREAAS in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-07-2014, 04:40 AM
  2. Summary Sheet with Headers
    By arichards in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2014, 09:08 PM
  3. Summary - Copy the columns based on column headers
    By rafiomeon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2012, 10:32 AM
  4. [SOLVED] Sorting dates:How do I sort a column filled with dates by Month, Day, then Year?
    By Heather in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-22-2005, 10:05 PM
  5. Fill column with dates of month depending on month in A1
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-10-2005, 09: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1