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.

Today's Date is 07/15/2013

Tomorrow is 07/16/2013If 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: 7000In cell B7 enter the formula: =SUMIF(A1:A5,TODAY()+1,B1:B5)

See how that works for you.

MIKE

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 ! :)

Ask Your Question

Weekly Poll

Do you think ride and car sharing are the future of transportation?

Discuss in The Lounge

Poll History