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

[sufian.naeem]

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

[TMS]

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

="Today's = " & INDEX($A$1:$A$4,MATCH($D$1,$B$1:$B$4,0))

Regards, TMS

[sufian.naeem]

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

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

="Today's = " & INDEX($A$1:$A$4,MATCH($D$1,$B$1:$B$4,0))

Regards, TMS

[sufian.naeem]

Here is the attachment ...
https://drive.google.com/file/d/0B3a...it?usp=sharing

[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:

="Today's = Rs. " & TEXT(INDEX($E$4:$E$38,MATCH(INT($A$2),$D$4:$D$38,0)),"0,000")

Regards, TMS

[sufian.naeem]

I want total "today's" to be Rs.: 55100 ..

So, how did you want it to work?

In your original post, you said

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:

="Today's = Rs. " & TEXT(INDEX($E$4:$E$38,MATCH(INT($A$2),$D$4:$D$38,0)),"0,000")

Regards, TMS

[sufian.naeem]

It should add up all amounts of "Today's Date" at the end..
and showing "today's" isnt really important... just the amount..

[sufian.naeem]

https://docs.google.com/spreadsheet/...Wc&usp=sharing
ATTACHMENT

[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.

[sufian.naeem]

LOL... im so sorry .. so sorry .. actually .. i changed it coz... i wanted You guys to know that i want to sum up 2 values.. not one.. and thats my mistake that i dint change "Suppose today is 13/12/13... Last Cell should show.. 4000" it needed to be changed as well.. well i dint want U to think of Me like im trying to be funny, wasting Your time..
Please Guide...

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.



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.

[TMS]

Then ...

=SUMIF(Table1[S. Date],INT(A2),Table1[Amount])

Regards, TMS

[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.