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;"<today()";S:S)
--------------------
and got 0 for an answer
I put
Code:
--------------------
=today()
--------------------
in the cell U1 and tried

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

Wahur


--
wahur
------------------------------------------------------------------------
wahur's Profile: http://www.excelforum.com/member.php...o&userid=26555
View this thread: http://www.excelforum.com/showthread...hreadid=540235