+ Reply to Thread
Results 1 to 2 of 2

Summing based on entered date

  1. #1
    Registered User
    Join Date
    12-16-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Summing based on entered date

    I have an excel 2010 spreadsheet and am looking for some help for a requirement as follows:

    I have a date column followed by a currency column (data types).

    When I enter something in both columns, I need to identify all rows having the same date and in another cell write the sum of all the currency columns.

    For example,

    A1 = 12/20/2012
    B1 = 250.00

    A2 = 12/21/2012
    B2 = 45.10

    A3 = 12/20/2012
    B3 = 10.00

    D1 = 12/20/2012
    E1 = 260.00


    I am not new to VBA so i'm aware that I can achieve this in VBA.

    My question: is there a built in way of doing this ?

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,038

    Re: Summing based on entered date

    Just use a formula

    in E1
    =SUMIF(A1:A1,D1,B1:B3)
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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