+ Reply to Thread
Results 1 to 2 of 2

Posting dollar amounts into one of 12 columns based on a date column in col A

  1. #1
    Registered User
    Join Date
    04-20-2004
    Posts
    2

    Question Posting dollar amounts into one of 12 columns based on a date column in col A

    My worksheet has a series of dates (in no special order), going down in column A
    There is a dollar amount for each of those dates listed in Col B
    The next 12 columns have months across the top labeled "JAN" though "DEC"

    I am trying to get the dollar amounts in Col B to post into the correct "JAN" though "DEC" column based on the date shown in Col A

    I hope I have explained my question clearly and will appreciate any and all suggestions

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,899

    Re: Posting dollar amounts into one of 12 columns based on a date column in col A

    C1 =1/1/2016
    D1 =2/1/2016
    ...
    Try this in C2:

    =SUMIFS($B$2:$B$5000,$A$2:$A$5000,">="&C1,$A$2:$A$5000,"<"&EDATE(C$1,1))
    Attached Files Attached Files

+ 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] creating total counts and dollar amounts based off a number inputed
    By Outlet Kings in forum Excel General
    Replies: 10
    Last Post: 06-19-2015, 04:19 PM
  2. Turning even Dollar Amounts to odd Dollar Amounts
    By Tim D in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-13-2015, 04:32 PM
  3. Dividing dollar amounts unevenly into varying numbers of cells/columns
    By Busterbrown in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-26-2014, 01:26 PM
  4. [SOLVED] Macro to Reformat Rows that contain date, dollar amounts, and other data
    By dean87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2013, 09:16 AM
  5. [SOLVED] Use of an array formula to sum dollar amounts based on date
    By Dralky in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-16-2013, 05:29 PM
  6. Replies: 4
    Last Post: 09-14-2011, 06:23 PM
  7. Replies: 2
    Last Post: 12-10-2009, 01:20 PM

Tags for this Thread

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