software

Column A has dates
Column S has numbers
I need to add numbers in rows where date is in past.
I tried
Code:
--------------------
=SUMIF(A:A;quot;lt;today()quot;;S:S)
--------------------
and got 0 for an answer
I put
Code:
--------------------
=today()
--------------------
in the cell U1 and tried

Code:
--------------------
=SUMIF(A:A;quot;lt;U1quot;;S:S)
--------------------
and still got 0 for an answer.
Whats wrong with the formula?

Wahur--
wahur
------------------------------------------------------------------------
wahur's Profile: www.excelforum.com/member.php...oamp;userid=26555
View this thread: www.excelforum.com/showthread...hreadid=540235
Wahur,

Change your original to:

=SUMIF(A:A,quot;lt;quot;amp;TODAY(),S:S)

You had quotes around the TODAY function which caused your problem.

HTH

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=540235
Thanks, works perfect!

Wahur--
wahur
------------------------------------------------------------------------
wahur's Profile: www.excelforum.com/member.php...oamp;userid=26555
View this thread: www.excelforum.com/showthread...hreadid=540235