Solved In excel sheet. i want to only add those cells(row) that con

July 15, 2013 at 15:58:10
Specs: Windows 7
A B 
1 13/7/13 4500
2 14/7/13 5000
3 14/7/13 10000
4 15/7.13 2000
5 Total 15000 

now i only want to sum 14/7/13..
Suppose today is 13/7... tomorrow is 14/7/13..
If i manually sum values for 14/7/13 of A2 and A3 (because only those cells contains tomorrow's dates).. answer will be 15000.
I wan excel to do it automatically. by checking computer's date..
telling me that tomorrow U have to pay this amount.

See More: In excel sheet. i want to only add those cells(row) that con

Report •


#1
July 15, 2013 at 16:18:18
✔ Best Answer
Today's Date is 07/15/2013
Tomorrow is 07/16/2013

If your data looks like:

        A                B
1) 07/15/2013	        4500
2) 07/16/2013	        5000
3) 07/17/2013	        10000
4) 07/16/2013	        2000
5) 07/19/2013	        15000
6)   	
7) Sum for Tomorrow: 	7000

In cell B7 enter the formula: =SUMIF(A1:A5,TODAY()+1,B1:B5)

See how that works for you.

MIKE

http://www.skeptic.com/


Report •

#2
July 15, 2013 at 16:25:17
awsomeee!!!!!
cant believe U just did it in a matter of seconds... :)
i'm finished with tonight's work.. :)
will bring something up tomorrow... :)
Thank You ! :)

Report •
Related Solutions


Ask Question