Putting Date in One Cell and Amount in the other... to get ---

Putting Dates in Column A... Putting Amounts in Column B...
Suppose today is 13/12/13... Last Cell should show.. 4000

2000	12/12/13
4000	13/12/13
5000	15/12/13
10000	13/12/13
Today's=14000

If the date you were looking for was in cell D1, you could use:

Formula:

Please Login or Register  to view this content.

Regards, TMS

The Formula isn't actually working the way i wanted it to ...

So, how did you want it to work?

In your original post, you said

Putting Dates in Column A... Putting Amounts in Column B

But then the example showed amounts and dates.

I worked with the the sample data, rather than what you said.

In the sample workbook that you uploaded to Dropbox, there are two dates, column A and column D, and an amount in column E. You haven't put any data in the workbook. And the formula in the merged cell in A2 is =NOW() which will also include the time.

So, taking all that into account, and assuming you want to look at the date in column D rather than column A (if they're different), the formula would be:

Formula:

Please Login or Register  to view this content.

Regards, TMS

You know, I'm pretty sure you've changed that last cell from 4000 to 14000. But you didn't change the description of what you expected there.

Suppose today is 13/12/13... Last Cell should show.. 4000

Which is what you got (using INDEX/MATCH).

If you want to get the total for one criterion, use SUMIF. If you have several criteria, use SUMIFS.

I'll leave it with you to look at the Help because I'm not very happy about you going back and moving the goalposts.

Then ...

Formula:

Please Login or Register  to view this content.

Regards, TMS

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.