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

Wahur,

Change your original to:

=SUMIF(A:A,"<"&TODAY(),S:S)

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

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=540235

Thanks, works perfect!

Wahur


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