Results 1 to 4 of 4

Having a formula count only specific dates.

Threaded View

  1. #1
    Registered User
    Join Date
    10-15-2008
    Location
    West Des Moines, IA
    MS-Off Ver
    Excel 2007
    Posts
    40

    Having a formula count only specific dates.

    Sorry, that title is atrocious for what I'm trying to do...

    Basic premise: On one sheet, I have two primary columns. One just has a date. It goes in order of the calendar year, but some dates may appear twice or three times in different rows, others none. They would appear sequentially. The second column just has a dollar amount.

    i.e.

    3/15/12 $10000
    3/15/12 $12000
    3/17/12 $15000


    etc.

    On a second sheet, I would like to make a formula that references what money is there for a given day.

    So, for March 15th, it would tabulate $22,000, March 16th, $0, and March 17th $15,000.

    And it would auto-adjust if I inserted new dates & numbers into the first sheet.

    I tried a couple of things and didn't have much luck, I included a sample of the first sheet for reference. Any help would be appreciated.
    Attached Files Attached Files
    Last edited by szm187; 03-15-2012 at 11:27 AM.

Thread Information

Users Browsing this Thread

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

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